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