public CommodityEntity GetUserByCommodity(Int32 M_Commodity_Slno) { String updateQuery = @"Select * From [M_Commodity] Where [M_Commodity_Slno] = @M_Commodity_Slno"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = updateQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Commodity_Slno", M_Commodity_Slno); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); DataTable dataTable = new DataTable(); dataTable.Load(dataReader); CommodityEntity existingcommodity = new CommodityEntity(); foreach (DataRow row in dataTable.Rows) { existingcommodity.M_Commodity_Slno = Convert.ToInt32(row["M_Commodity_Slno"]); existingcommodity.M_Commodity_Name = Convert.ToString(row["M_Commodity_Name"]); existingcommodity.M_Commodity_Sname = Convert.ToString(row["M_Commodity_Sname"]); } return(existingcommodity); } }
protected void ibtnEdit_Click(object sender, ImageClickEventArgs e) { GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer; Int32 M_Commodity_Slno = Convert.ToInt32(gvCommodity.DataKeys[gvRow.RowIndex].Value); CommodityEntity commodity = GetUserByCommodity(M_Commodity_Slno); // Now set value to modal popup commodityid1.Value = commodity.M_Commodity_Slno.ToString(); txtcommodityname1.Text = commodity.M_Commodity_Name; txtcommodityshortname1.Text = commodity.M_Commodity_Sname; mpeCommodity1.Show(); }
protected void ibtnView_Click(object sender, ImageClickEventArgs e) { //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Successfully')", true); GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer; Int32 M_Commodity_Slno = Convert.ToInt32(gvCommodity.DataKeys[gvRow.RowIndex].Value); CommodityEntity commodity = GetUserByCommodity(M_Commodity_Slno); // Now set value to modal popup commodityid2.Value = commodity.M_Commodity_Slno.ToString(); viewcommodityname.Text = commodity.M_Commodity_Name; viewcommodityshortname.Text = commodity.M_Commodity_Sname; mpeCommodity2.Show(); }
protected void btnSave_Click1(object sender, EventArgs e) { if (Page.IsValid) { CommodityEntity commodity = new CommodityEntity(); commodity.M_Commodity_Slno = Convert.ToInt32(commodityid1.Value); commodity.M_Commodity_Name = txtcommodityname1.Text.Trim(); commodity.M_Commodity_Sname = txtcommodityshortname1.Text.Trim(); if (commodity.M_Commodity_Slno != 0) { UpdateCommodity(commodity); } LoadData(); } }
public bool AddNewCommodity(CommodityEntity user) { String insertQuery = @"INSERT INTO [M_Commodity] ([M_Commodity_Name],[M_Commodity_Sname]) VALUES(@M_Commodity_Name, @M_Commodity_Sname)"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = insertQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Commodity_Name", user.M_Commodity_Name); cmd.Parameters.AddWithValue("@M_Commodity_Sname", user.M_Commodity_Sname); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); } }
public bool UpdateCommodity(CommodityEntity user) { String updateQuery = @"UPDATE [M_Commodity] SET [M_Commodity_Name] = @M_Commodity_Name ,[M_Commodity_Sname] = @M_Commodity_Sname Where [M_Commodity_Slno] = @M_Commodity_Slno"; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _ConnStr; SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = updateQuery; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@M_Commodity_Slno", user.M_Commodity_Slno); cmd.Parameters.AddWithValue("@M_Commodity_Name", user.M_Commodity_Name); cmd.Parameters.AddWithValue("@M_Commodity_Sname", user.M_Commodity_Sname); if (conn.State == ConnectionState.Closed) { conn.Open(); } cmd.ExecuteNonQuery(); return(true); } }