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);
}
}
