public ChargeEntity GetCharge(Int32 M_Charge_Code)
{
String updateQuery = @"Select * From [M_Charge]
Where [M_Charge_Code] = @M_Charge_Code";
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_Charge_Code", M_Charge_Code);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader dataReader =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
DataTable dataTable = new DataTable();
dataTable.Load(dataReader);
ChargeEntity existingcharge = new ChargeEntity();
foreach (DataRow row in dataTable.Rows)
{
existingcharge.M_Charge_Code = Convert.ToInt32(row["M_Charge_Code"]);
existingcharge.M_Charge_Name = Convert.ToString(row["M_Charge_Name"]);
existingcharge.M_Charge_Sname = Convert.ToString(row["M_Charge_Sname"]);
}
return(existingcharge);
}
}
protected void ibtnEdit_Click(object sender, ImageClickEventArgs e)
{
GridViewRow gvRow = (GridViewRow)((ImageButton)sender).NamingContainer;
Int32 M_Charge_Code = Convert.ToInt32(gvCharge.DataKeys[gvRow.RowIndex].Value);
ChargeEntity charge = GetCharge(M_Charge_Code);
// Now set value to modal popup
chargeidEditpopup.Value = charge.M_Charge_Code.ToString();
txtchargenameEditpopup.Text = charge.M_Charge_Name;
txtchargeshortnameEditpopup.Text = charge.M_Charge_Sname;
mpeChargeEditpopup.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_Charge_Code = Convert.ToInt32(gvCharge.DataKeys[gvRow.RowIndex].Value);
ChargeEntity charge = GetCharge(M_Charge_Code);
// Now set value to modal popup
chargeidEditpopup.Value = charge.M_Charge_Code.ToString();
txtchargenameEditpopup.Text = charge.M_Charge_Name;
txtchargeshortnameEditpopup.Text = charge.M_Charge_Sname;
mpeChargeViewpopup.Show();
}
protected void btnSave_Click1(object sender, EventArgs e)
{
if (Page.IsValid)
{
ChargeEntity charge = new ChargeEntity();
charge.M_Charge_Code = Convert.ToInt32(chargeidAddpopup.Value);
charge.M_Charge_Name = txtchargenameAddpopup.Text.Trim();
charge.M_Charge_Sname = txtchargeshortnameAddpopup.Text.Trim();
if (charge.M_Charge_Code != 0)
{
UpdateCharge(charge);
}
LoadData();
}
}
public bool AddNewCharge(ChargeEntity charge)
{
String insertQuery = @"INSERT INTO [M_Charge] ([M_Charge_Name],[M_Charge_Sname]) VALUES(@M_Charge_Name, @M_Charge_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_Charge_Name", charge.M_Charge_Name);
cmd.Parameters.AddWithValue("@M_Charge_Sname", charge.M_Charge_Sname);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
}
public bool UpdateCharge(ChargeEntity charge)
{
String updateQuery = @"UPDATE [M_Charge] SET [M_Charge_Name] = @M_Charge_Name ,[M_Charge_Sname] = @M_Charge_Sname Where[M_Charge_Code] = @M_Charge_Code";
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_Charge_Code", charge.M_Charge_Code);
cmd.Parameters.AddWithValue("@M_Charge_Name", charge.M_Charge_Name);
cmd.Parameters.AddWithValue("@M_Charge_Sname", charge.M_Charge_Sname);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
cmd.ExecuteNonQuery();
return(true);
}
}
