public UtilityModel GetUtilityInfo(int UtilityID = 0)
{
ShomaRMEntities db = new ShomaRMEntities();
UtilityModel model = new UtilityModel();
model.UtilityID = 0;
model.UtilityTitle = "";
model.UtilityDetails = "";
var UtilityInfo = db.tbl_Utility.Where(p => p.UtilityID == UtilityID).FirstOrDefault();
if (UtilityInfo != null)
{
model.UtilityID = UtilityInfo.UtilityID;
model.UtilityTitle = UtilityInfo.UtilityTitle;
model.UtilityDetails = UtilityInfo.UtilityDetails;
}
return(model);
}
public long SaveUpdateUtility(UtilityModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
var utilityExists = db.tbl_Utility.Where(p => p.UtilityID != model.UtilityID && p.UtilityTitle == model.UtilityTitle).FirstOrDefault();
if (utilityExists == null)
{
if (model.UtilityID == 0)
{
var data = new tbl_Utility()
{
UtilityTitle = model.UtilityTitle,
UtilityDetails = model.UtilityDetails,
};
db.tbl_Utility.Add(data);
db.SaveChanges();
model.UtilityID = data.UtilityID;
}
else
{
var utilityInfo = db.tbl_Utility.Where(p => p.UtilityID == model.UtilityID).FirstOrDefault();
if (utilityInfo != null)
{
utilityInfo.UtilityTitle = model.UtilityTitle;
utilityInfo.UtilityDetails = model.UtilityDetails;
db.SaveChanges();
}
else
{
throw new Exception(model.UtilityTitle + " not exists in the system.");
}
}
return(model.UtilityID);
}
else
{
throw new Exception(model.UtilityTitle + " already exists in the system.");
}
}