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);