public ValidationMsg Update(SysTransHead objSysHead, int userID)
{
var vmMsg = new ValidationMsg();
try
{
var Head = _context.Sys_TransHead.FirstOrDefault(s => s.HeadID == objSysHead.HeadID);
if (Head != null)
{
Head.HeadName = objSysHead.HeadName;
Head.HeadCode = objSysHead.HeadCode;
Head.HeadCategory = objSysHead.HeadCategory == "Addition" ? "AD" : "DD";
Head.HeadType = DalCommon.ReturnTransHeadType(objSysHead.HeadType);
Head.IsActive = objSysHead.IsActive == "Active";
Head.ModifiedOn = DateTime.Now;
Head.ModifiedBy = userID;
}
_context.SaveChanges();
vmMsg.Type = Enums.MessageType.Update;
vmMsg.Msg = "Updated Successfully.";
}
catch (Exception ex)
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to update.";
}
return(vmMsg);
}
public ValidationMsg Save(SysTransHead objSysHead, int userID)
{
var vmMsg = new ValidationMsg();
try
{
var tblSysHead = new Sys_TransHead
{
HeadName = objSysHead.HeadName,
HeadCode = objSysHead.HeadCode,
HeadCategory = objSysHead.HeadCategory == "Addition" ? "AD" : "DD",
HeadType = DalCommon.ReturnTransHeadType(objSysHead.HeadType),
IsActive = objSysHead.IsActive == "Active",
SetOn = DateTime.Now,
SetBy = userID,
ModifiedOn = DateTime.Now,
ModifiedBy = userID,
IPAddress = string.Empty
};
_context.Sys_TransHead.Add(tblSysHead);
_context.SaveChanges();
HeadID = tblSysHead.HeadID;
vmMsg.Type = Enums.MessageType.Success;
vmMsg.Msg = "Save Successfully.";
}
catch (Exception ex)
{
vmMsg.Type = Enums.MessageType.Error;
vmMsg.Msg = "Failed to save.";
}
return(vmMsg);
}
public IEnumerable <SysTransHead> GetAll()
{
IEnumerable <SysTransHead> iLstSysHead = (from sg in _context.Sys_TransHead.AsEnumerable()
//where sg.IsActive == true
select new SysTransHead
{
HeadID = sg.HeadID,
HeadName = sg.HeadName,
HeadCode = sg.HeadCode,
HeadCategory = sg.HeadCategory == "AD" ? "Addition" : "Deduction",
HeadType = DalCommon.ReturnTransHeadType(sg.HeadType),
IsActive = sg.IsActive == true? "Active" : "Inactive",
}).ToList();
return(iLstSysHead);
}
