protected void dgvdistrict_RowEditing(object sender, GridViewEditEventArgs e) { DistrictId = Convert.ToInt32(dgvdistrict.DataKeys[e.NewEditIndex].Value); BusinessLayer.SMS.district objdistrict = new BusinessLayer.SMS.district(); Entity.SMS.district district = new Entity.SMS.district(); district = objdistrict.GetAllById(DistrictId); txtdistrictname.Text = district.DistrictName.ToString(); txtShortName.Text = district.ShortName.ToString(); btnsubmit.Text = "update"; }
protected void btnsubmit_Click(object sender, EventArgs e) { BusinessLayer.SMS.district objdistrict = new BusinessLayer.SMS.district(); Entity.SMS.district Entitydistrict = new Entity.SMS.district(); Entitydistrict.DistrictId = DistrictId; Entitydistrict.DistrictName = txtdistrictname.Text.Trim(); Entitydistrict.ShortName = txtShortName.Text.Trim(); objdistrict.Save(Entitydistrict); loaddistrict(); clearcontrol(); }
public static void Save(Entity.SMS.district Entitydistrict) { using (DataManager oDm = new DataManager()) { oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.InputOutput, Entitydistrict.DistrictId); oDm.Add("@pDistrictName", SqlDbType.VarChar, 50, Entitydistrict.DistrictName); oDm.Add("@pShortName", SqlDbType.VarChar, 50, Entitydistrict.ShortName); oDm.Add("@pIsActive", SqlDbType.Bit, Entitydistrict.IsActive); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("sp_district_save"); } }
public static Entity.SMS.district GetAllById(int DistrictId) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@pDistrictId", SqlDbType.Int, ParameterDirection.Input, DistrictId); SqlDataReader dr = oDm.ExecuteReader("usp_district_GetAllById"); Entity.SMS.district Entitydistrict = new Entity.SMS.district(); if (dr.HasRows) { while (dr.Read()) { Entitydistrict.DistrictId = DistrictId; Entitydistrict.DistrictName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString(); Entitydistrict.ShortName = (dr[2] == DBNull.Value) ? "" : dr[2].ToString(); Entitydistrict.IsActive = (dr[3] == DBNull.Value) ? true : Convert.ToBoolean(dr[3].ToString()); } } return(Entitydistrict); } }
public void Save(Entity.SMS.district Entitydistrict) { DataAccess.SMS.district.Save(Entitydistrict); }