We're developing a business ASP.NET application. Is it better to pass an entire entity to a method or pass each property of this entity as parameters? What is the best practice?
Case 1. Pass Customer entity to a manager - InsertCustomer(Customer cust)
Case 2. Pass each property as a parameter - InsertCustomer(string name, string address...etc)
I have an ObjectDataSource that I want to perform updates using a business entity i.e. Type="Object"). Since the values for the entity are within a user control, I have stored a reference to the control in Session and in the updating event, set the new instance to the value of the entity from the user contol property (which also pulls values from the form viaother properties of the control):
Protected Sub MasterDataSource_Updating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceMethodEventArgs) Handles MasterDataSource.Updating
Dim entity As New Login()
Dim accountControl As AccountInfo = TryCast(Session("AccountCtrl"), AccountInfo)
entity = accountControl.Entity
e.InputParameters.Add("entity", entity)
End Sub
And here's the markup for the datasource:
<asp:ObjectDataSource ID="MasterDataSource" runat="server" EnableCaching="true" CacheDuration="10"
SelectMethod="SelectAll" UpdateMethod="Update" TypeName="Data.DAL.LoginDAL">
</asp:ObjectDataSource>
My question is, how can I get the update method to pass this entity to the update method in my BLL class? It seems the Update method requires an ID or reference to the original object to use in determining whether any changes have taken place, but I don't really want to do this. In other words, I just want to use the Update event on my ObjectDataSource to pass my entity to the method ("Update") I set as a property and then let this business method handle the update of the data. Shown below, is the BLL update method I want to call:
Public Overloads Function Update(ByVal entity As Login)
If entity Is Nothing Then
Throw New ArgumentNullException("entity")
End If
MyBase.Update("UpdateLogin", entity.Username, entity.Password, entity.FirstName, entity.LastName, entity.Role, entity.Region, _
entity.Email, entity.Title, entity.TierID, entity.Street, entity.City, entity.State, entity.Zip, entity.Mobile, entity.Phone, entity.Fax)
End Function
When I try to call this as it stands now, I get an error: ObjectDataSource 'MasterDataSource' could not find a non-generic method 'Update' that has parameters: ID, entity. Previously, I'd set up a long list of parameters of basic data types (string, int, boolean), but this is rather cumbersome and I was hoping to use an entity for this (FYI, I also got the same type of error when I tried this approach, but with the ID as the
last parameter in the list). Perhaps what I'm doing here is atypical to how the ODS is normally used?? Has anyone done something like this successfully?
i am working in the webservice project. I have one project when i run it then shows the text box for parameters and return the result after passing the parameters.
But another webservice does not allow me to enter the paramerters when execute then list of methods displayed and then show the soap xml when click at any method.
what difference found in both webserivces are Excuting-one that have the Text boxes: Test: "To test the operation using the HTTP POST protocol, click the 'Invoke' button."
2nd One Not provide the parameter text boxes: Test: "The test form is only available for methods with primitive types as parameters"
Dont know how to fix that. Because i want to debug the webservice and as i am unable to provide the parameter then how can i fix it.
how can i pass the parameters in the 2nd webservice as it has different information mentioned above.
how to pass parameters to the selectmethod property of the objectdatasource control.
View 1 RepliesI'm calling PageMethod "SameMethod" from javascript method "caller" so that I can get some values from DB. After I get values, control is continuing in "onSuccess" method. Problem is that I need to use some variable values ("importantValue") from javascript method "caller" in "onSuccess" method.
function caller(){
var importantValue = 1984;
PageMethod.SomeMethod(param1,..., onSuccess, onFailure)
}
onSuccess method should be something like this:
function onSuccess(pageMethodReturnValue, importantValue ){
}
Is it possible and, if it is, how to pass multiple parameters (besides return values of page method) to "onSuccess" method of PageMethod?
Since ASP.NET MVC3 RC2 I encounter a bug when posting values to a controller method of which one of the parameter is a nullable int. Steps to reproduce:
I've created a test method
[code]....
In MVC3 RC1 this was working without any problems with the nullable int
Update:
I don't seem to have the problem with a newly created MVC3 website. What could I have in my project that influence model binding to nullable int's? And why would there be a difference between RC1 and RC2?
I don't know why, but even using update panel, my postback method updates the entire page. I'm using a master page with aspScriptManager inside.
My ASP.Net code:
<div> <asp:UpdatePanel ID="updProva" runat="server">
<ContentTemplate> <asp:Panel ID="pnlProva" runat="server">
</asp:Panel> </ContentTemplate> </asp:UpdatePanel> </div>
The CodeBehind (C#) creating some RadioButtonList controls in my ASP.Net page, I'll post the main function and de Page_Load:
createTest function
[Code]....
Finally, the Page_Load:
[Code]....
I have a site with about 4 pages or so. I was asked to implement a very simple security (check if user in database, if not kick out) using active directory and validating against a table of users. I was simply thinking of createing a master page and making all pages inherit that master page. I would then authenticate the users from the master page.
View 4 Replieshow to set readonly property in property method(get and set).
View 2 Replies I use EF 4 and C #.
I need populate a Pure Junction Table (containing only FK to other tables) when an EntityDataSource _Inserted event is raised.
I have 3 Tables in my Database:
[code]....
Here a useful resource:
But I am not able to implment it:
[code]....
I have an MVC3 app that I just added new db model to. I have created the connection to the database and I'm able to drag some tables and stored procedures onto the design surface. I have one sproc, however, that is giving me the above error.
Below is the script for the sproc in question. I am new to this and don't know what I might be missing. Where do I set the udttypename property?
[Code]....
I want to create a view that draws from mutiple sources of data and creates a 'summary' view.This would include:An author (data source A) A list of the authors latest writings (data source B) A list of topics the author writes about (data source A)I notice I cannot pass into ...return View(author, articles, topics) from the controller.It seems you have to pick one.I want to construct my View from multiple partial views for each type.Not sure I am trying to do this the correct way.
View 6 RepliesI'm trying to keep track of employees in my database. I have two tables, Employees and Departments. The Employees table contains a foreign key relationship with Departments through a column named DepartmentID.
Here's my entity:
[code]....
I have a page that contains a form to add an employee. I'm passing the entity to my view page, and calling <%: Html.EditorForModel() %>
The problem is that the view creates a textbox for the DepartmentID.
How can I force the view to display a dropdown for DepartmentID that contains all the Departments in my database as the dropdown's list items? Is there a way to do this by just adding a metadata attribute to the property in my entity?
I have two Entity classes: Order and OrderItem. Order contains a navigation property OrderItemSet of type
System.Data.Objects.DataClasses.EntityCollection<OrderItem>
On an aspx page is a FormView bound to this EntityDataSource:
[code]....
When I run the application I get an exception pointing to the line DataSource='<%# Eval("OrderItemSet")%>' in markup and telling me:
DataBinding: System.Web.UI.WebControls.EntityDataSourceWrapper does not contain a property with name 'OrderItemSet'
What is wrong here?
I am using the Entity Framework for the first time and want to know if the following is possible - I have generated my classes from the DB, and have one called Category.
Obviously it has all my fields in the table (ID, CategoryName, SortOrder etc..) but I want to know if I can add a custom property which is not in the table, but is actually the result of a custom method.
I want to add a new property called 'CategoryURL' which is basically the 'CategoryName' property run through a custom method and returns a hyphenated string.
My initial thought is inheriting from the generated Category class and creating something like this inside?
public string CategoryURL
{
get{ return MyCustomMethod(this.CategoryName) }
}
Is this the correct approach? And will 'this.CategoryName' work as I think it should? Basically the end result is when I return a list of 'Category' I want this to be part of the class so I can use it in my foreach loop.
I have a page containing a link to to MS Excel spreadsheet (I am able to assume that Excel is available as this is an intranet page). All works fine until I want to pass a parameter into the spreadsheet.
Normally I would do this with /e but this will not work I am starting Excel through a link.
Any ideas how I would pass the parameters into Excel?
(also - there may be multiple requests for the spreadsheet at any time with differing parameters!!)
i'm having a little problem in my project. i'm using ADO.Net Entity Data Model, let's say i have 2 Tables:
Offices : a. id
b. Name
Requests: a. rid
b.fname
c.lname
d.mobile
i want the requests table will have a relations to the offices table that each row in requests will have the id of the one of the tables. i tried to do 1 to many relations but it didn't work , i just couldnt add data to the table.
I am using LINQ-to-Entities and here is my query
public void SomeFunction(string searchField)
{
var data = from a in dx.SomeTable where [code]...
Now if I had to use the value of the parameter "searchField" as the property to be selected in the where clause then how do I do it ?
i.e I want to assign the value of the parameter "searchField" to the property I am checking in the where clause.
So ... the value of "SomeProperty" in a.SomeProperty must be the value of "searchField". How to do this ?
PS : I dont want a.SomeProperty=searchField. What I want is "SomeProperty" itself to be replaced by the value of "searchField" and then , this has to be checked to see if its equal to 270.
Im using Entity framework with POCO entity generator template + SQL Server. I have mapping to stored procedure that takes two floats as input.
After executing function from code with two doubles as parameters: 1.23 and 4.56, SQL Profiler shows:
exec storedProcedureName @arg1 = 1,23, @arg2= 4,56
This is causing an error because it looks like that stored procedure takes 4 arguments, but it should take only two and there should be dots insted of commas in these floats.
[code]....
Instead of specifying 10 parameters in the URL, is there any good alternative way of passing the parameters? And note the new window has to be a popup.
View 6 RepliesI used a sub in which need to pass about 15 parameters. How to simplify it?
Protected Sub test(ByVal _a As String, ByVal _b As String) //about 15 parameters will pass
Dim s As String = "insert into AAA a, b value(" & _a & ", " & _b & ")"
End Sub
I'm building a site that has a number of language versions. currently I use session variable to manage the country code for different language version
but today the client specifically requires to put the country code in the url right behind the domain name so the site url will be like these examples
uk version: [URL]
usa version: [URL]
I defined the default route to
[URL]
but I'm not sure how to get the first segment of the url in the controllers?
<a runat="server" id="link" href='ProductDetails.aspx?ID=<%# Eval("productID") %>'></a>
View 2 RepliesMy problem with the following is how do I send the ModelStateErrors to the action Employee, when I go through the catch part in DeleteEmployee
[Code].....
With return View("Employee", model); I a still not able to send the ID and Name as parameter.
crystal report has two parameters field, however, i used three method searched, all failed. Error is missing parameter values. sure parameter is passing by query string URL] checked by Label However, do not know why Error is missing parameter values.
Method 1
// First parameter
ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();
crParameterDiscreteValue.Value = Request.QueryString["ID"];
crParameterFieldDefinitions = objRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["Cheque_IssueRecord_Secretary_Review_TT_ID"];
crParameterValues = crParameterFieldDefinition.CurrentValues;
crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
// Second parameter
ParameterFieldDefinitions crParameterFieldDefinitions2;
ParameterFieldDefinition crParameterFieldDefinition2;
ParameterValues crParameterValues2 = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue2 = new ParameterDiscreteValue();
crParameterDiscreteValue2.Value = Request.QueryString["tCOMDB"];
crParameterFieldDefinitions2 = objRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition2 = crParameterFieldDefinitions2["tCOMDB"];
crParameterValues2 = crParameterFieldDefinition2.CurrentValues;
crParameterValues2.Clear();
crParameterValues2.Add(crParameterDiscreteValue2);
crParameterFieldDefinition2.ApplyCurrentValues(crParameterValues2);
Method 2
//objRpt.SetParameterValue("Cheque_IssueRecord_Secretary_Review_TT_ID", Request.QueryString["ID"]);
//objRpt.SetParameterValue("tCOMDB", Request.QueryString["tCOMDB"]);
Method 3
var value = new ParameterDiscreteValue();
value.Value = Request.QueryString["ID"];
objRpt.ParameterFields["Cheque_IssueRecord_Secretary_Review_TT_ID"].CurrentValues.Add(value);
var value2 = new ParameterDiscreteValue();
value2.Value = Request.QueryString["tCOMDB"];
objRpt.ParameterFields["tCOMDB"].CurrentValues.Add(value2);
This crystal report database use stored procedure, parameter field is automatically added, after added i removed @ character do not know why parameter missing