public BusinessEntity.Result DeleteGrade(BusinessEntity.Lookup.GradeEntity Grade)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblGrades.Find(Grade.ID);
if (original != null)
{
e.tblGrades.Remove(e.tblGrades.Where(x => x.ID == Grade.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 UpdateGrade(BusinessEntity.Lookup.GradeEntity Grade)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
var original = e.tblGrades.Find(Grade.ID);
if (original != null)
{
e.Entry(original).CurrentValues.SetValues(Grade);
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.GradeModel GetGradeByID(int GradeID)
{
BusinessLogic.Lookup.GradeManager GradeManager = new BusinessLogic.Lookup.GradeManager();
BusinessEntity.Lookup.GradeEntity Grade = GradeManager.GetGradeByID(GradeID);
return(new Models.Lookup.GradeModel(Grade));
}
public GradeModel(BusinessEntity.Lookup.GradeEntity grade)
{
this.ID = grade.ID;
this.Name = grade.Name;
this.Description = grade.Description;
this.CreatedBy = grade.CreatedBy;
this.CreatedDate = grade.CreatedDate;
}
public T MapToEntity <T>() where T : class
{
BusinessEntity.Lookup.GradeEntity grade = new BusinessEntity.Lookup.GradeEntity();
grade.ID = this.ID;
grade.Name = this.Name;
grade.Description = this.Description;
grade.CreatedBy = this.CreatedBy;
grade.CreatedDate = this.CreatedDate;
return(grade as T);
}
public BusinessEntity.Result SaveGrade(BusinessEntity.Lookup.GradeEntity Grade)
{
BusinessEntity.Result result = new BusinessEntity.Result();
try
{
SchoolInformationManagementSystemDBEntities e = new SchoolInformationManagementSystemDBEntities();
e.tblGrades.Add(Grade.MapToModel <DataAccessLogic.tblGrade>());
e.SaveChanges();
result.Message = "Saved Successfully.";
result.Status = true;
return(result);
}
catch (Exception)
{
result.Message = "Failed to save";
result.Status = false;
return(result);
}
}
