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