public JsonResult SearchSectorByCodeNo(string CodeNumber)
{
SectorDataAccess obj = new SectorDataAccess();
tbl_Sector lst = new tbl_Sector();
lst = obj.GetSectorbyCode(CodeNumber);
if (lst != null)
{
return(Json(new { result = lst, ErrorMessage = CustomMessages.Success }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = lst, ErrorMessage = CustomMessages.NoValueExist }, JsonRequestBehavior.AllowGet));
}
}
public tbl_Sector GetSectorbyID(int ID)
{
try
{
tbl_Sector row = new tbl_Sector();
using (var db = new SoneriCISEntities())
{
row = db.tbl_Sector.FirstOrDefault(e => e.ID == ID);
}
return(row);
}
catch (Exception ex)
{
throw ex;
}
}
public tbl_Sector GetSectorbyCode(string Code)
{
try
{
tbl_Sector row = new tbl_Sector();
using (var db = new SoneriCISEntities())
{
row = db.tbl_Sector.FirstOrDefault(e => e.Code == Code);
}
return(row);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddSector(tbl_Sector row)
{
try
{
using (var db = new SoneriCISEntities())
{
db.tbl_Sector.Add(row);
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool DeleteSector(tbl_Sector row)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Sector val = new DAL.tbl_Sector();
val = db.tbl_Sector.Where(a => a.ID == row.ID).FirstOrDefault();
val.IsActive = false;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool UpdateSector(tbl_Sector row)
{
try
{
using (var db = new SoneriCISEntities())
{
tbl_Sector val = new DAL.tbl_Sector();
val = db.tbl_Sector.Where(a => a.Code == row.Code).FirstOrDefault();
val.Code = row.Code;
val.Description = row.Description;
val.IsActive = row.IsActive;
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public JsonResult UpdateSector(string SectorDescription, string Code, bool?IsActive)
{
bool success;
SectorDataAccess obj = new SectorDataAccess();
tbl_Sector lst = new tbl_Sector();
//ConfigurationVM lst = new ConfigurationVM();
lst.Description = SectorDescription;
lst.Code = Code;
lst.IsActive = IsActive;
success = obj.UpdateSector(lst);
if (success == true)
{
return(Json(new { result = success, ErrorMessage = CustomMessages.Success }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = success, ErrorMessage = CustomMessages.GenericErrorMessage }, JsonRequestBehavior.AllowGet));
}
}
public bool CheckSector(string Code)
{
try
{
tbl_Sector row = new tbl_Sector();
using (var db = new SoneriCISEntities())
{
row = db.tbl_Sector.FirstOrDefault(e => e.Code == Code && e.IsActive == true);
}
if (row != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
partial void Deletetbl_Sector(tbl_Sector instance);
partial void Updatetbl_Sector(tbl_Sector instance);
partial void Inserttbl_Sector(tbl_Sector instance);
