public void GetDOFAData(int _dataCaptYM, string empDept = "")
{
EmpDept = empDept;
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (_dataCaptYM > 0 ? _dataCaptYM : 0);
this.DofaData = formsRepository.GetDOFAFormDataByID(DataCaptYM, SessionManager.DeptID, empDept);
if (DofaData == null || DofaData.Count == 0)
{
DofaData = new List <DofaInfo>();
DofaData.Add(new DofaInfo());
DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
}
else
{
DataStatus = DofaData.First().DataStatus;
DataStatusName = DofaData.First().DataStatusName;
}
if (!string.IsNullOrWhiteSpace(EmpDept))
{
DofaData.ForEach(f => f.empDEPT = EmpDept);
}
}
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);
}