private void lookupTAApprovalNoPrefix_EditValueChanged(object sender, EventArgs e)
{
if (lookupTAApprovalNoPrefix.EditValue != null)
{
txtTAApprovalNo.EditValue = DALObject.GenerateTAApprovalNo((int)lookupTAApprovalNoPrefix.EditValue);
}
else
{
txtTAApprovalNo.EditValue = 0;
}
}
private void gridviewImportData_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
TAApprovalImportViewModel Row = (TAApprovalImportViewModel)gridviewImportData.GetRow(e.RowHandle);
if (Row == null)
{
return;
}
gridviewImportData.PostEditor();
if (e.Column == colApprovalNoPrefixName)
{
if (Row.ApprovalNoPrefixID == null || Row.ApprovalNoPrefixID == 0)
{
Row.ApprovalNoPrefixNameError = "Approval No. Prefix not selected.";
}
else
{
Row.ApprovalNoPrefixNameError = null;
// if duplicate found in current records, then generate new
if (Row.ApprovalNo == null || Row.ApprovalNo == 0 || dsImportedData.Where(r => r.RowNo != Row.RowNo).Any(r => r.ApprovalNoPrefixID == Row.ApprovalNoPrefixID && r.ApprovalNo == Row.ApprovalNo))
{
int No = DALObj.GenerateTAApprovalNo(Row.ApprovalNoPrefixID.Value);
No = Math.Max(No, (dsImportedData.Where(r => r.RowNo != Row.RowNo && Row.ApprovalNoPrefixID == Row.ApprovalNoPrefixID).Max(r => r.ApprovalNo) ?? 0) + 1);
Row.ApprovalNo = No;
}
}
}
else if (e.Column == colApprovalNo)
{
}
else if (e.Column == colEmployeeName)
{
var employee = dsEmployee.FirstOrDefault(r => r.EmployeeID == Row.EmployeeID);
if (employee != null)
{
Row.EmployeeNo = employee.EmployeeNo;
Row.EmployeeNoPrefixName = employee.EmployeeNoPrefix;
}
}
}