public BusinessEntity.Result DeleteRegion(BusinessEntity.Lookup.RegionEntity Region)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblRegions.Find(Region.ID);
if (original != null)
{
e.tblRegions.Remove(e.tblRegions.Where(x => x.ID == Region.ID).First());
e.SaveChanges();
result.Message = "Deleted Successfully.";
result.Status = true;
return(result);
}
else
{
result.Message = "Failed to delete";
result.Status = false;
return(result);
}
}
catch (Exception)
{
result.Message = "Failed to delete";
result.Status = false;
return(result);
}
}
public BusinessEntity.Result UpdateRegion(BusinessEntity.Lookup.RegionEntity Region)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblRegions.Find(Region.ID);
if (original != null)
{
e.Entry(original).CurrentValues.SetValues(Region);
e.SaveChanges();
result.Message = "Updated Successfully.";
result.Status = true;
return(result);
}
else
{
result.Message = "Failed to update";
result.Status = false;
return(result);
}
}
catch (Exception)
{
result.Message = "Failed to update";
result.Status = false;
return(result);
}
}
public Models.Lookup.RegionModel GetRegionByID(int RegionID)
{
BusinessLogic.Lookup.RegionManager RegionManager = new BusinessLogic.Lookup.RegionManager();
BusinessEntity.Lookup.RegionEntity Region = RegionManager.GetRegionByID(RegionID);
return(new Models.Lookup.RegionModel(Region));
}
public RegionModel(BusinessEntity.Lookup.RegionEntity region)
{
this.ID = region.ID;
this.Name = region.Name;
this.Description = region.Description;
this.CreatedBy = region.CreatedBy;
this.CreatedDate = region.CreatedDate;
}
public T MapToEntity <T>() where T : class
{
BusinessEntity.Lookup.RegionEntity region = new BusinessEntity.Lookup.RegionEntity();
region.ID = this.ID;
region.Name = this.Name;
region.Description = this.Description;
region.CreatedBy = this.CreatedBy;
region.CreatedDate = this.CreatedDate;
return(region as T);
}
public BusinessEntity.Result SaveRegion(BusinessEntity.Lookup.RegionEntity Region)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
e.tblRegions.Add(Region.MapToModel <DataAccessLogic.tblRegion>());
e.SaveChanges();
result.Message = "Saved Successfully.";
result.Status = true;
return(result);
}
catch (Exception)
{
result.Message = "Failed to save";
result.Status = false;
return(result);
}
}
