public Models.Lookup.SubCityModel GetSubCityByID(int SubCityID)
{
BusinessLogic.Lookup.SubCityManager SubCityManager = new BusinessLogic.Lookup.SubCityManager();
BusinessEntity.Lookup.SubCityEntity SubCity = SubCityManager.GetSubCityByID(SubCityID);
return(new Models.Lookup.SubCityModel(SubCity));
}
public BusinessEntity.Result DeleteSubCity(BusinessEntity.Lookup.SubCityEntity SubCity)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblSubCities.Find(SubCity.ID);
if (original != null)
{
e.tblSubCities.Remove(e.tblSubCities.Where(x => x.ID == SubCity.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 UpdateSubCity(BusinessEntity.Lookup.SubCityEntity SubCity)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblSubCities.Find(SubCity.ID);
if (original != null)
{
e.Entry(original).CurrentValues.SetValues(SubCity);
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 SubCityModel(BusinessEntity.Lookup.SubCityEntity subCity)
{
this.ID = subCity.ID;
this.Name = subCity.Name;
this.Description = subCity.Description;
this.CreatedBy = subCity.CreatedBy;
this.CreatedDate = subCity.CreatedDate;
}
public T MapToEntity <T>() where T : class
{
BusinessEntity.Lookup.SubCityEntity subCity = new BusinessEntity.Lookup.SubCityEntity();
subCity.ID = this.ID;
subCity.Name = this.Name;
subCity.Description = this.Description;
subCity.CreatedBy = this.CreatedBy;
subCity.CreatedDate = this.CreatedDate;
return(subCity as T);
}
public BusinessEntity.Result SaveSubCity(BusinessEntity.Lookup.SubCityEntity SubCity)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
e.tblSubCities.Add(SubCity.MapToModel <DataAccessLogic.tblSubCity>());
e.SaveChanges();
result.Message = "Saved Successfully.";
result.Status = true;
return(result);
}
catch (Exception)
{
result.Message = "Failed to save";
result.Status = false;
return(result);
}
}
