public Boolean SaveUtility(Utility.Data.Utility utility)
{
if (string.IsNullOrEmpty(utility.Utility_ID.ToString())) // New Record
{
using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext())
{
dbContext.Utilities.Add(utility);
dbContext.SaveChanges();
return(true);
}
}
else // Update Record
{
using (UtilitySaleDBContext dbContext = new UtilitySaleDBContext())
{
Utility.Data.Utility Utility = dbContext.Utilities.Where(x => x.Utility_ID == utility.Utility_ID).FirstOrDefault();
Utility.Utility_Name = utility.Utility_Name;
Utility.Is_Active = utility.Is_Active;
Utility.City_ID = utility.City_ID;
Utility.Updated_On = DateTime.Now;
Utility.Updated_By = "user";
return(true);
}
}
}
public void BindData()
{
int UtilityID = Convert.ToInt32(Request.QueryString["UtilityID"]);
Utility.Data.Utility utility = GetUtilityByID(UtilityID);
txtUtilityName.Text = utility.Utility_Name;
ddlCity.Items.FindByValue(utility.City_ID.ToString()).Selected = true;
if (utility.Is_Active == true)
{
chkIsActive.Checked = true;
}
else
{
chkIsActive.Checked = false;
}
}
