|
hopefully I recken i write right code
public ItemRepository()
{
// instantiate the connection
_connection = new SqlConnection(datasource);
}
//definition of insert method
public void Insert(string code, string description, DateTime created, string creator)
{
//definition of SQl SP parameters
_sqlcommand = new SqlCommand("Ins_item",_connection);
_sqlcommand.CommandType = CommandType.StoredProcedure;
_sqlcommand.Parameters.AddWithValue("@Code", code);
_sqlcommand.Parameters.AddWithValue("@Description", description);
_sqlcommand.Parameters.AddWithValue("@Created", created);
_sqlcommand.Parameters.AddWithValue("@Creator", creator);
_datareader = _sqlcommand.ExecuteReader();
}
}
I did the above code in MODEL folder of MVC project.
would you mind telling me what I have to write in the controler folder
|
|
|
|
|
Your code goes in the pre tags, not your message e.g.
public ItemRepository()
{
_connection = new SqlConnection(datasource);
}
Anyway, you're closer there but your insert method's a little off. It's a void, meaning it's not returning anything, therefore you don't need _datareader, your command should be running .ExecuteNOnQuery rather than ExecuteReader.
When you say controler folder, could you elaborate more please?
|
|
|
|
|
I fixed up the code as you said.
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
namespace MvcApplication1.Models.Repository.DTO
{
public class Item
{
public int _id;
public int _code;
public string _description;
public string _creator;
public DateTime _created;
public int Id
{
set
{
_id = value;
if (value < 0)
throw new ArgumentException(string.Format("Id should be greater than 0 !"));
}
get { return _id; }
}
public int Code
{
set { _code = value; }
get { return _code; }
}
public string Description
{
set { _description = value; }
get { return _description; }
}
public string Creator
{
set { _creator = value; }
get { return _creator; }
}
public DateTime Created
{
set { _created = value; }
get { return _created; }
}
public Item(int id, int code, string description, string creator, DateTime created)
{
this._id = id;
this._code = code;
this._description = description;
this._creator = creator;
this._created = created;
}
}
}
then in Model part in another class I write:
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using MvcApplication1.Models.Repository.DTO;
namespace MvcApplication1.Repository
{
public class ItemRepository
{
private const string datasource =
"Data Source= Dell\\SQLEXPRESS;Initial Catalog=DB_Furniture.mdf;Integrated Security=True;User Instance=True";
private SqlConnection _connection;
private SqlCommand _sqlcommand;
private SqlDataReader _datareader;
public ItemRepository()
{
_connection = new SqlConnection(datasource);
}
public void Insert(string code, string description, DateTime created, string creator)
{
_sqlcommand = new SqlCommand("Ins_item",_connection);
_sqlcommand.CommandType = CommandType.StoredProcedure;
_sqlcommand.Parameters.AddWithValue("@Code", code);
_sqlcommand.Parameters.AddWithValue("@Description", description);
_sqlcommand.Parameters.AddWithValue("@Created", created);
_sqlcommand.Parameters.AddWithValue("@Creator", creator);
_datareader = _sqlcommand.ExecuteNOnQuery();
}
}
}
the problem is here. I don't know what should I write in Controller part.I craete a controller class.
ing System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Mvc.Ajax;
using MvcApplication1.Models.Repository.DTO;
using MvcApplication1.Models.Repository;
using MvcApplication1.Repository;
namespace MvcApplication1.Controllers
{
public class FurnitureController : Controller
{
public ActionResult Index()
{
return View();
}
public ActionResult Create()
{
return View();
}
public ActionResult Craete(Item item)
{
try
{
ItemRepository ItemRep = new ItemRepository();
??????????????????????????????????????????????????????????????????????????????????
?
??
}
catch
{
}
}
}
}
PLease heap me. its a week. I went through many samples and article on the internet.
|
|
|
|
|
er... look at your code, it's all ok, you just need to call it in your controller class. You've already instantiated an object for your data access class so just...call the function off of it.
To put it another way, how do you use methods and properties off of a class? I really can't make it any simpler without writing the entire thing for you.
|
|
|
|
|
dude, the problem is I don't know how to call it. do u have any sample, please?
|
|
|
|
|
Seriously, you're going to kick yourself for this when you realize what I meant. Ok, you've got it here:
Member 4674360 wrote: public ActionResult Craete(Item item)
{
try
{
ItemRepository ItemRep = new ItemRepository();
??????????????????????????????????????????????????????????????????????????????????
?
??
}
catch
{
}
}
In your actual code, you've created a method called "insert" off of ItemRepository .
Ergo you just need to call it.
As an example:
Class DataAccessorX
{
public void DeployFrickingLazers(int A, int B, int C)
{
...
}
}
Class MazingerZ
{
public void WeNeedKillingPowerNow()
{
DataAccessorX oldSkoolAnime = new DataAccessorX();
oldSkoolAnime.DeployFrickingLazers(ArmOnePilotID, ArmTwoPilotID, ArmThreePilotID);
}
}
|
|
|
|
|
Hi All,
I have a details view which contains a datagrid. They are both populating fine but now I want to edit the rows in the datagrid.
I'm setting up the datagrid like so:
protected override void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
DataGrid productCulturesDataGrid = ((DataGrid)ProductDetailsView.FindControl("ProductsCultureDataGrid"));
productCulturesDataGrid.EditCommand += new DataGridCommandEventHandler(this.ProductsCultureDataGrid_EditCommand);
this.Load += new System.EventHandler(this.Page_Load);
}
And then in the page load method i'm setting the datasource like so:
List<ProductsCultureInfo> productCultures = (List<ProductsCultureInfo>)ListOfProductCultures();
DataGrid productCulturesDataGrid = ((DataGrid)ProductDetailsView.FindControl("ProductsCultureDataGrid"));
productCulturesDataGrid.DataSource = productCultures;
productCulturesDataGrid.DataBind();
The EditCommand method looks like this but is never triggered:
private void ProductsCultureDataGrid_EditCommand(object sender, DataGridCommandEventArgs e)
{
DataGrid ProductsCultureDataGrod = (DataGrid)ProductDetailsView.FindControl("ProductsCultureDataGrid");
ProductsCultureDataGrod.EditItemIndex = e.Item.ItemIndex;
}
Any ideas what i'm doing wrong? Also not sure if this has anything to do with it but this is a dotnetnuke module.
Thanks
Phil
P.S. here is the ascx page encase that helps
<asp:DetailsView ID="ProductDetailsView" runat="server" Height="50px" Width="125px" EnableModelValidation="True" AutoGenerateRows="False">
<Fields>
<asp:BoundField DataField="ProductID" HeaderText="Product ID" Visible="False" />
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label ID="NameLabel" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Description">
<ItemTemplate>
<asp:Label ID="DescriptionLabel" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Thumbnail">
<ItemTemplate>
<asp:TextBox ID="ThumbnailTextBox" runat="server" Text='<%# Bind("ThumbURL") %>' />
<asp:Image ID="ThumbnailImage" runat="server" ImageUrl='<%# Bind("ThumbURL") %>' />
<asp:LinkButton ID="cmdUpdateThumbnail" runat="server" BorderStyle="None" Text="Test URL" OnClick="cmdUpdateThumbnail_Click" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Ext Product ID">
<ItemTemplate>
<asp:TextBox ID="ExtProductIDTextBox" runat="server" Text='<%# Bind("ExtProductID") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Builder Type">
<ItemTemplate>
<asp:DropDownList ID="BuilderTypesDropDownList" runat="server">
<asp:ListItem>Calendars</asp:ListItem>
<asp:ListItem>Cards and Stationery</asp:ListItem>
<asp:ListItem>Gifts</asp:ListItem>
<asp:ListItem>Photobooks</asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Active">
<ItemTemplate>
<asp:CheckBox ID="ActiveCheckBox" runat="server" Checked='<%# Bind("Active")%>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Culture Variations">
<ItemTemplate>
<asp:DataGrid ID="ProductsCultureDataGrid" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundColumn DataField="ItemID" HeaderText="ProductCultureID" Visible="False">
</asp:BoundColumn>
<asp:BoundColumn DataField="CultureCode" HeaderText="Culture Code"></asp:BoundColumn>
<asp:BoundColumn DataField="Name" HeaderText="Name"></asp:BoundColumn>
<asp:BoundColumn DataField="Description" HeaderText="Description"></asp:BoundColumn>
<asp:BoundColumn DataField="Currency" HeaderText="Currency"></asp:BoundColumn>
<asp:BoundColumn DataField="CurrencySymbol" HeaderText="Currency Symbol"></asp:BoundColumn>
<asp:BoundColumn DataField="Price" HeaderText="Price"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="Symbol At Front?">
<ItemTemplate>
<asp:CheckBox ID="SymbolAtFront" runat="server" Checked='<%# Bind("SymbolAtFront") %>' />
</ItemTemplate>
</asp:TemplateColumn>
<asp:EditCommandColumn EditText="Edit" ButtonType="PushButton"></asp:EditCommandColumn>
</Columns>
</asp:DataGrid>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:Button ID="AddNewCultureButton" runat="server" Text="Add Culture Variation" OnClick="AddNewCultureButton_Click" />
</ItemTemplate>
</asp:TemplateField>
</Fields>
</asp:DetailsView>
|
|
|
|
|
Still trying to solve this, anyone got any ideas at all?
|
|
|
|
|
Hi All,
I have a scenario. I have two javascript files attached in my aspx page. I have a function which is present in both the files. I want to call the method from first file only.
Is there any way of doing this other then changing the order of the attached files
Regards
|
|
|
|
|
Overload the methods with different number of parameters.
It's not good to have two methods of same name and same signature. Either overload them or change the name.
|
|
|
|
|
Change the name of the other function name to different.
|
|
|
|
|
You can use namespaces in JavaScript, although it is unconventional and a better approach would be, as the others have suggested, rename the method(s)
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
When i am setting the Readonly property of a textbox to true and then, changing the textbox's value,
The changed value doesn't get populated to the server on postback.
Is there any alternative for this.
I achieved this by setting the txtName.Attributes.Add("readonly", "readonly");
Need your comment if there is any better method.
|
|
|
|
|
I'm not sure what you're trying to achieve here?
Scenario 1: You want to be able to alter the text so that it gets posted back to the server but in which case...why are you trying to make it read only? Read only means just that, you're not meant to change it.
Scenario 2: You want the text to be unchangeable. Use the .enabled flag to false on the control.
|
|
|
|
|
It is not allowed to change the value of the textbox which is readonly.
When it is readonly then why are you changing it. What is your requirement?
|
|
|
|
|
The textbox is readonly for the user.
But i want to change it through javascript based on some criteria and get the changed value to the server.
|
|
|
|
|
One more way, you can do this use a property ContentEditable make it false, then you'll be able to update it from client side.But you'll get some warning for this property.Otherwise better way do as Sandeep suggested.
|
|
|
|
|
Brij wrote: you can do this use a property ContentEditable
Do we have such Property for TextBox in Asp.Net 4.0??
|
|
|
|
|
Anurag Gandhi wrote: the Readonly property of a textbox to true and then, changing the textbox's value,
How are you able to change a value of textbox when it's readonly?
Readonly means you cannot change.
& If you want to change why readonly?
|
|
|
|
|
Sorry for my initial post.
I am changing the textbox value in the the client side using Javascript.
|
|
|
|
|
You have marked the field as readonly. You wont be able to change it and thus you don't find the change on server side.
If you want to use a changed value of the shown readonly field, use hidden field for it. Set the new value in hidden field and access it in code-behind.
|
|
|
|
|
Can you not just disable the textbox and then change the text property? Then it will appear as if readonly but you should still be able to change the value.
|
|
|
|
|
Yes we can, it's just that disabled text would be light grayed... and evident that its disabled. If it's not a concerning issue then surely we can go for it.
It's just that, one prefers readonly because of the text visibility in general.
|
|
|
|
|
Have your javascript set a hidden field and read the value server-side from that.
|
|
|
|
|
Dear all,
Please help.
I created BasePage to open connection as following
Public Class BasePage
Inherits System.Web.UI.Page
public Dim acon As New SqlConnection
Protected Overridable Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
acon= new SqlConnection(ConfigurationManager.ConnectionStrings("DOCDBDWHConnectionString").ConnectionString)
acon.open()
End Sub
Inherits to normal page is works.
But don't know how do use that connection in MasterPage
Partial Class Site
Inherits System.web.UI.MasterPage
Please help me how to make MasterPage know that connection?
Thanks and Best Regards
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
