public ValidationMsg Create(SysGradeRange objSysGradeRange)
{
var vmMsg = new ValidationMsg();
try
{
var tblSysGradeRange = new Sys_GradeRange
{
GradeRangeID = objSysGradeRange.GradeRangeID,
GradeRangeName = objSysGradeRange.GradeRangeName,
Description = objSysGradeRange.Description,
IsActive = objSysGradeRange.IsActive,
IsDelete = objSysGradeRange.IsDelete,
SetOn = DateTime.Now,
SetBy = 25,
ModifiedOn = DateTime.Now,
ModifiedBy = 25,
IPAddress = string.Empty
};
_context.Sys_GradeRange.Add(tblSysGradeRange);
_context.SaveChanges();
vmMsg.Type = Enums.MessageType.Success;
vmMsg.Msg = "Save Successfully.";
}
catch (Exception ex)
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to update.";
}
return(vmMsg);
}
public ValidationMsg Delete(SysGradeRange objSysGradeRange)
{
var vmMsg = new ValidationMsg();
try
{
var tblSysGradeRange = _context.Sys_GradeRange.FirstOrDefault(s => s.GradeRangeID == objSysGradeRange.GradeRangeID);
if (tblSysGradeRange != null)
{
tblSysGradeRange.GradeRangeName = objSysGradeRange.GradeRangeName;
tblSysGradeRange.Description = objSysGradeRange.Description;
tblSysGradeRange.IsActive = Convert.ToBoolean(objSysGradeRange.IsActive);
tblSysGradeRange.IsDelete = true;
tblSysGradeRange.ModifiedOn = DateTime.Now;
tblSysGradeRange.ModifiedBy = 27;
}
_context.SaveChanges();
vmMsg.Type = Enums.MessageType.Success;
vmMsg.Msg = "Deleted Successfully.";
}
catch (Exception ex)
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to update.";
}
return(vmMsg);
}
public List <SysGradeRange> GetGradeformation()
{
var result = _context.Sys_GradeRange.Where(ob => ob.IsDelete == false).ToList();
List <SysGradeRange> lst = new List <SysGradeRange>();
foreach (var item in result)
{
SysGradeRange ob = new SysGradeRange();
ob.GradeRangeID = item.GradeRangeID;
ob.GradeRangeName = item.GradeRangeName;
ob.Description = item.Description;
lst.Add(ob);
}
return(lst);
}
