public bool AddSector(string sectorName)
{
try
{
RC_SECTORS sector = new RC_SECTORS()
{
SECTOR_NAME = sectorName,
IsDelete = false,
// SECTOR_ID = _db.RC_SECTORS.Select(x=>x.SECTOR_ID).Last() + 1 //remove in production
};
_db.RC_SECTORS.Add(sector);
_db.Entry(sector).State = System.Data.Entity.EntityState.Added;
_db.SaveChanges();
return(true);
}
catch (Exception ex)
{
_log.Error(ex.StackTrace);
}
return(false);
}
public bool DeleteSector(long sectorId)
{
try
{
RC_SECTORS sector = _db.RC_SECTORS.Where(x => x.SECTOR_ID == sectorId).Select(x => x).FirstOrDefault();
//_db.RC_SECTORS.Remove(sector);
sector.IsDelete = true;
_db.Entry(sector).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
return(true);
}
catch (Exception ex)
{
_log.ErrorFormat("Unable to delete for this reason:: {0}", ex.StackTrace);
}
return(false);
}
public bool UpdateSector(long sectorId, string sectorName)
{
try
{
RC_SECTORS sector = _db.RC_SECTORS.Where(x => x.SECTOR_ID == sectorId).Select(x => x).FirstOrDefault();
sector.SECTOR_NAME = sectorName;
_db.Entry(sector).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
return(true);
}
catch (Exception ex)
{
_log.Error(ex.StackTrace);
}
return(false);
}