public string InsertOrUpdate(RegionModel RM) { string result = string.Empty; bool IsExsit = false; tbl_Region Region; Region = this.GetById(RM.RegionID); if (Region != null) { IsExsit = true; } else { Region = new tbl_Region(); } Region.RegionID = RM.RegionID; Region.RegionName = RM.RegionName; if (!IsExsit) { return(result = this.Insert(Region)); } else { return(result = this.Update(Region)); } }
public tbl_Region SV_GetSQLRegionsById(int id) { DataOperations sqlDataOperation = new DataOperations(); tbl_Region region = sqlDataOperation.GetRegionById(id); return(region); }
public tbl_Region SV_GetSQLRegionsById(int id) { CRUDOperation cRUDOperation = new CRUDOperation(); tbl_Region region = cRUDOperation.GetRegionById(id); return(region); }
public string InsertOrUpdateRegion(RegionModel RM) { tbl_Region Region = new tbl_Region(); Region.RegionID = RM.RegionID; Region.RegionName = RM.RegionName; return(RegionBL.InsertOrUpdate(RM)); }
public IHttpActionResult AddRegion(tbl_Region item) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } CRUDOperation operation = new CRUDOperation(); tbl_Region dbitem = operation.AddRegion(item); return(Ok(dbitem)); }
public void UpdateRegion(tbl_Region tblRegion) { try { IGenericDataRepository <tbl_Region> repository = new GenericDataRepository <tbl_Region>(); repository.Update(tblRegion); } catch (Exception) { throw; } }
public tbl_Region FindRegionName(string regionName) { try { IGenericDataRepository <tbl_Region> repository = new GenericDataRepository <tbl_Region>(); tbl_Region tblRegion = repository.GetSingle(c => c.Region.ToUpper() == regionName.ToUpper()); return(tblRegion); } catch (Exception) { throw; } }
public tbl_Region FindRegion(int?Id) { try { IGenericDataRepository <tbl_Region> repository = new GenericDataRepository <tbl_Region>(); tbl_Region tblRegion = repository.GetSingle(c => c.Id == Id); return(tblRegion); } catch (Exception) { throw; } }
public IHttpActionResult UpdateRegion(tbl_Region item) { CRUDOperation operation = new CRUDOperation(); if (item == null) { return(NotFound()); } else { var dbitem = operation.UpdateRegion(item); return(Ok(dbitem)); } }
public bool AddRegion(tbl_Region row) { try { using (var db = new SoneriCISEntities()) { db.tbl_Region.Add(row); db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public PartialViewResult GetRegionById(int RegionID) { RegionModel RM = new RegionModel(); tbl_Region Region; Region = RegionBL.GetById(RegionID); if (Region == null) { Region = new tbl_Region(); } RM.RegionID = Region.RegionID; RM.RegionName = Region.RegionName; return(PartialView("~/Views/Region/Partial/_RegionDetailsPartial.cshtml", RM)); }
public void DeleteRegion(RegionViewModel regionViewModel) { try { tbl_Region tblRegion = new tbl_Region(); tblRegion.Id = regionViewModel.Id; tblRegion.EntityState = DA.DomainModel.EntityState.Deleted; RegionManager regionManager = new RegionManager(); regionManager.DeleteRegion(tblRegion); } catch (Exception) { throw; } }
public void AddRegion(RegionViewModel regionViewModel) { try { tbl_Region tblRegion = new tbl_Region(); tblRegion.Region = regionViewModel.Region; tblRegion.EntityState = DA.DomainModel.EntityState.Added; RegionManager regionManager = new RegionManager(); regionManager.AddRegion(tblRegion); } catch (Exception) { throw; } }
/// <summary> /// Update Region /// </summary> /// <param name="Region"></param> /// <returns></returns> public string Update(tbl_Region region) { try { Context.Region.Update(region); Context.Region.Save(); return(region.RegionID + " Updated Successfully!!"); } catch (Exception ex) { //POS Log Exception to db table return("Error in saving details, Please try again!!"); } finally { // Context = null; } }
public bool UpdateRegion(tbl_Region row) { try { using (var db = new SoneriCISEntities()) { tbl_Region val = new tbl_Region(); val = db.tbl_Region.Where(a => a.Description == row.Description).FirstOrDefault(); val.Title = row.Title; val.FED = row.FED; val.IsActive = row.IsActive; db.SaveChanges(); } return(true); } catch (Exception ex) { return(false); } }
public JsonResult UpdateBranch(string Description, string Tilte, string FED, bool?IsActive) { bool success; RegionDataAccess obj = new RegionDataAccess(); tbl_Region lst = new tbl_Region(); //ConfigurationVM lst = new ConfigurationVM(); lst.Description = Description; lst.Title = Tilte; lst.FED = FED; lst.IsActive = IsActive; success = obj.UpdateRegion(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)); } }