public bool SaveDOFAData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (DofaData == null || DofaData.Count == 0)
{
return(success);
}
if (DofaData.Any(n => n.empNo <= 0 || string.IsNullOrWhiteSpace(n.empName) || string.IsNullOrWhiteSpace(n.empDEPT)))
{
msg = "Minimum EmpNo, Name, Dept should not be blank";
return(success);
}
if (DofaData.GroupBy(n => n.empNo).Any(c => c.Count() > 1))
{
msg = "Duplicate EmpNo Exist.! Data saving aborted.";
return(success);
}
foreach (var item in DofaData)
{
item.MenuID = DataAccess.Enum.Menu.DOFA.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(DofaData);
success = formsRepository.UpdateBulkDOFAFormData(dt, SessionManager.DataCaptYR, SessionManager.DeptID, EmpDept);
}
catch (Exception ex)
{
}
return(success);
}