Business Layer Vs SQL Server
Jan 24, 2012
I have an application that does complex calculations for members. Each member can have multiple US states linked to their profile. Each state has got different calculations for each course a member completes. As of now I have been performing the calculations in the DB (SQL Server 2008) and then sending data back to app layer where they can see their history and then download a certificate for each course. I have a business logic layer but not a lot happens there. I know this has been asked a lot but where do you think I should perform these calculations: business layer or database? I am going back and forth
View 3 Replies
ADVERTISEMENT
Oct 1, 2010
I also went though the whole "ASP.Net in 24 Hours" book by Scott Mictchell. I followed everything that went on in that book and built the final project successfully. I also used the tutorials here to better understand the whole Membership Provider/User tables setup that was going on in the book. Next, I thought I would learn more about accessing data for ASP.Net since that is what most application do.I went through the first Data Tutorial here. I seemed to understand what was going on just fine.The second Data Tutorial seemed to just show a lot of VB code to build the Business Logic Layer. There was not much explanation about how to do it yourself.I think I can keep going in the tutorials here. I downloaded the code from the second tutorial and went through it.I am guessing that the code in the second tutorial was given just to proceed with the overall project that is being built throughout the tutorial sequence.
View 2 Replies
Sep 24, 2009
If code the parameter list as seperate arguments then this wouldnt be a problem, but following a taught pattern that i should take collection as parameters in update or create methods.
Assume the there are three members in a class and in the update or create methods that was told code them to take collection, therefore create.
update methods of that class take collection but the problme the caller faces that it doesnt know the order and names of each element of the collection.
Assume :[code...]
View 2 Replies
Sep 7, 2011
I have a shopping cart ListView control backed by a custom object that has methods for selecting and deleting. In the ListView, one of the columns is an ImageButton that is essentially a delete icon, with the CommandName parameter set to CommandName="Delete".
My issue is related to updating the shopping cart ListView on delete; as the delete method is stored in the custom business entity object, I am having trouble in terms of updating the calculations made inside the cart (we have deleted an item, so I need to recalc shipping, taxes, etc).
[Code]...
View 1 Replies
Aug 25, 2009
IN my daat access layer, the stored procedure returns value of the format "CCT1". But i need to format that value to "CCT00001". Should i do this formatting in the data access layer or in the business layer?
View 4 Replies
Feb 7, 2011
I am generally following this tutorial, the main differences being I'm using 2008 R2 Express and Windows Forms, he is using 2005 & ASP.NET Web Site:'m building a minimalist Windows Form project for learning purposes. So I'm using a 1-table database with 2 columns, ContactID & Name. I added a dataset file, 'ContactsDataSet.xsd' to my project and added a single minimalist table adapter with just a fill() & getdata() method.Then I added a DataGridView control and connected it to the ContactsDataSet to confirm it was working and that worked fine. I ran it and it filled up with data as expected. Everything up to this point was auto-generated code.
View 4 Replies
Oct 11, 2010
using an object-binding I have a an object representing "Employee". The employee has an ID-property. The ID of the employee must be unique.
My validation of the entered data is handled in the property set part of the object. In general, I validate criteria belonging to the object to validate only (eg numeric range of the ID, if it's value is not empy, ...). But in this case I need to know all ID's from the other employees. My tried this:
''' <summary>
''' Set EmployeeID
''' </summary>
[Code].....
View 2 Replies
May 28, 2009
Need a SQL Server "SQLClient" (VB) Data Layer Class?
View 2 Replies
Nov 30, 2010
I am working in VB.NET defining my own classes. I have 5 classes, Policy, Coverage, CoverageCollection, Layer, and LayerCollection. Policy has a bunch of data items, one of which is of type CoverageCollection. Coverage has a bunch of data items, one of which is of type LayerCollection.
Policy
private id as Long
private name as String[code].....
Then I do like "dim p as Policy". So, iIn order to get to properties on a Layer, I reference it like p.cov(0).lyr(0).face. What I am trying to do is add a readonly property to Layer that is calculated using some Layer information but also using something from Coverage (or even Policy). I can take this in as a parameter to the property, but I think there should be a way to get at Coverage/Policy information since I am "under" it already. Is there a way to do this?
View 1 Replies
Jul 26, 2009
I am trying to prototype an application with a data layer on my computer at home using Visual Basic 2008 express edition with SQL Server Compact 3.5. My production situation at work is SQL Server 2000 and I am using Visual Basic 2005 professional for development.I am trying to write the code to create a seperate data layer. Here is my code. First the data layer:
Imports
System.Data
Imports[code].....
My Problem is that the data does not show up in the text boxes.
View 1 Replies
Feb 24, 2011
Ok, so I was playing around with Ninject, a "Service Layer" and a "Repository Layer".I built a simple console application to to play around, this is what I came up with:
Imports Ninject
Module Module1
Sub Main()
Dim Kernel As IKernel = New StandardKernel(New CustomerModule)
Dim Service = Kernel.Get(Of CustomerService)()
Console.WriteLine(Service.GetCustomerByID(1).Name)
Console.Read()
[Code]...
View 2 Replies
Jun 27, 2010
I am attempting to create an application for my (very) small businessRight now I am trying to create an "Add a Customer" formI know VERY LITTLE about MySql so I thought I would save the text into a textfile.. I then realized I do not know how to save multiple text box in a text file (I only knew how to save one text box in a text file)
View 14 Replies
Sep 2, 2009
This is a debate that can never be fulfilled without you. Please come forward and respond.What if we have a client who wants to develop a web enterprise application (based on SAAS architecture) and prefers for C# and not VB.NET based. Argument can be:
1. C# is better suited for developing enterprise application versus VB.NET
2. C# is object oriented versus VB.NET is not
3. Programming in C# is faster than VB.NET
4. Libraries/function blocks in VS.NET is more for C# versus VB.NET
I would request you to help me answer this. I believe this is the type of questions many faces when deciding for which language to go for, both developers and organizations.
View 1 Replies
Apr 19, 2009
Due to a discussion in another thread , I am starting to use business object in an 3-Tiered windows app. As a starting point, I am trying to build objects/classes on a table from my database.
The database table has the following columns:
ID
TypeID
Reference
[Code]....
View 1 Replies
Jun 17, 2009
The issue I'm currently having is mapping multiple GUI fields to object properties (i.e. Presentation layer to Business Logic Layer mapping). To be more specific, this is in VB.Net 2.0 WinForms. The nature of the solution requires us to have 4 columns which exhibit the same type of behavior on our GUI - each column consisting of 11 textboxes (we'll just use this small sample size, as the problem extends beyond 11 textboxes).
What I am currently doing is setting the tag of each textbox in all four columns to a value like so:
Textbox1.tag = "name"
Textbox2.tag = "type"
Textbox3.tag = "speed"
[Code]...
As you can see this can get very bad, rather quickly. Currently we're setting 43 some odd properties that can be mapped to -- thus that select statement is extremely long -- many of which are embedded in multiple methods to try and attempt DRY (I've watered down the code to essentially a conceptual implementation).
Question is: how can I refactor this? I've attempted using a dictionaries/hashes to a certain extent, but it either became overly complex, or just plain didn't make an implementation sense as it convoluted the problem even more.
View 1 Replies
Jan 30, 2011
I have a form which has two panels each containing there own controls (Pnl1, Pnl2). By Default I want Pnl1 to show and Pnl2 to be hidden which I have set but I want Pnl2 to sit ontop of Pnl1 so when Pnl2 is selected Pnl2 is Visiable and Pnl1 is hidden. Therefore Pnl2 and the controls sit in the same place as the controls in Pnl1. I have got everything lined up but as I move Pnl2 over Pnl1 to sit ontop, Pnl2 is moved into Pnl1 and becomes a Panel within the Controls of Pnl1. Therefore when I hide Pnl1 everything is hidden as Pnl2 is part of Pnl1.
View 1 Replies
Mar 20, 2012
I was having a discussion with a colleague about a method used to check business rules. In general there are two conditions:
"If one fails the whole thing fails"
Example 1: "If one fails the whole thing fails"I have used the following technique for condition 1 in several cases. Essentially if one of those conditions is false then the whole thing fails
Dim blnTemp As Boolean = True
If Fail=False Then blnTemp = blnTemp AndAlso False
{code code code}
[code]....
View 3 Replies
May 20, 2011
does a big business in shirts, especially for groups and teams. They need a project that will calculate the price for individual orders, as well as a summary for all orders.The store employee will enter the orders in an order form that has text boxes for customer name and order number. To specify the shirts, use a text box for the quantity, radio buttons to select the size (small, medium, large, extra large, and XXL), and check boxes to specify a monogram and/or a pocket. Display the shirt price for the current order and the order total in labels.
Include buttons to add a shirt to an order, clear the current item, complete the order, and display the summary of all orders. Do not allow the summary to display if the current order is not complete. Also, disable the text boxes for customer name and order number after an order is started; enable them again when the user clicks on the button to begin a new order. Confirm the operation before clearing the current order.
When the user adds shirts to an order, validate the quantity, which must be greater than zero. If the entry does not pass the validation, do not perform any calculation but display a message box and allow the user to correct the value. Determine the price of the shirts from the radio buttons and check boxes for the monogram and pockets. Multiply the quantity by the price to determine the extended price, and add to the order total and summary total
The assignment also requires a pop up message "Daily Summary" with total shirts sold, total sales, and average sale per customer.So far I have this as my code but I am not sure what needs to change in order to display the correct total shirts- mine only displays the last accepted shirt order.
[Code]...
View 1 Replies
Sep 17, 2009
I am writing a program that takes a shipdate and generates a timeline of deadlines for a manufacturing job by working backwards from the shipdate. I hav no problem handling weekends. However, some holidays are giving me problems. For holidays that don't have a set date (Thanksgiving, Labor Day, Memorial Day...) what is the best way to determine the date they fall on? Most of the examples I have seen use an array of dates (either from a file or hard coded) for these holidays. Is there a way to do this tha won't require someon to generate a list every year for these holidays?
View 3 Replies
Jun 22, 2012
I need to calculate the end date given the number of business days (excluding weekend and holidays). All the examples I've seen so far return the number of business days between a start date and an end date.
View 1 Replies
Jun 21, 2010
I have a custom business object called Customer and a Form1 with a BindingSource1, NumericUpDown1, TextBox1 and ComboBox1 and the attached code. Setting break points in the Property Sets shows that the Set for the ComboBox never fires at all even though the Set for the NumericUpDown and TextBox fire like crazy. [code]
View 1 Replies
Mar 23, 2012
Anyone knows how to generate a list of all dates of all working days of a specific year?
View 3 Replies
Oct 5, 2010
I'm working with BCM to create Business Project. I'm able to create the Business Project but what i would like to do that to create the Business Project with it's ItemProperties Vaue. For example : BusinessProject.ItemProperties("Project Start Date").Value = dtpStartDate.Value.Date. It gives an error (System.NullReferenceException: Object Reference not set to an instance of an object).
But when i edit the existing Business Project it allows me to add ItemProperties Value.
View 4 Replies
Aug 18, 2011
his running an XP network and wants to put some real-time monitoring in place on his staff and what they're doing.
View 13 Replies
Feb 1, 2011
(using VB2008)I was wondering if it's possible to implement dynamic (runtime) formulas between objects and properties. My inspiration is Excel, where any cell can have a hardcoded value or be a function of other cells. So via analogy of a property acting like a cell, depending upon the situation, I would like to either give it a defined value or make it a function of other properties of objects of the same type.
There seem to be two basic levels of functionality, 1) the dependent property recalculates its value every time it's accessed, or better is 2) it detects when its input properties change value and recalculates itself only once (as in Excel). But so far I've failed to find any way to do either with ordinary properties. It seems like I would either have to turn each property into a class (and use events, references to parent properties, etc), or use reflection heavily. Either way I feel like I'm going off the beaten path and making things complicated. Has anyone done something like this?
View 8 Replies
Feb 16, 2010
i am currently trying, to create some sort of a business logic within my class, that contains information about a machine, now this machine once sold, can be re-sold by its owner. the company needs to keep track of the machine and its owner for warranty claim purposes.the class takes in two values, a from date and a to date.now when a new owner is added to the owner collection of the machine, the TO date of the previous owner should automatically be updated to one day less than the From date of the new owner that is being added.
View 1 Replies
Aug 16, 2010
I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.
View 7 Replies
Dec 8, 2011
I search google and oracle forums before I came here with this question.
Is someone familiar with VB.NET and Oracle Form (11.5) interaction.
I just want to login in the Oracle E-Business Suite from VB.NET.
I hope to find the anwser here.
View 4 Replies
Jun 7, 2009
below i have a piece of code, i have to calculate the next working day +5 from today but this calculation has to calculate days from monday to friday and exclude weekends(saturday & sunday) and also excluse public holidays.i have tried but what i got is that it calculates 5days without excluding anything.example if a record is taken out monday, the return date must be the next monday but with this code calculates weekends as well it says return date is saturday.
Public Function AddWorkingDays(ByVal DateIn As DateTime, _
ByVal ShiftDate As Integer) As DateTime
' Adds the [ShiftDate] number of working days to DateIn
[code]....
View 1 Replies
Dec 6, 2011
I have several successive web pages going through a checkout process and they each have tons of business logic that time restraints limit me from pulling out and wrapping up elsewhere in the code the way it needs to be. What would be a good method for calling each one of these pages' Submit buttons in order from one page to the next?
The way I was going to do this was to (laugh at me go ahead) make PUBLIC all of the submit buttons' code and just call them. But what I have found is that all of them have, of course, certain calls to controls on their pages where it might make a label visible or change a text property then that will crash the app due to a null reference. I believe it is basically saying if the webpage is not visible then it is not going to let the code start setting certain GUI properties of the controls on the page. It seems like I recall this in VB6, too.
Anyway, what would you do if you were in this situation? I have started down the path of creating a flag that says whether or not I am in expresscheckoutmode and, if so, it just doesn't do the "illegal" things mixed into all of the code like making labels visible and all that. But that also means that I have an IF BLOCK everywhere where the code simply changes a label. It junked up the code bad and I still haven't finished that implementation of it all. I wanted to come here to ask the collective mind what programming principles I can best apply here.
View 4 Replies
