public bool IsAllowedEdit(Login currentUser, TraCrfDto data)
{
if (currentUser.EMPLOYEE_ID == data.EMPLOYEE_ID &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.AssignedForUser)
{
return(true);
}
if (currentUser.UserRole == Enums.UserRole.HR &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.Draft)
{
return(true);
}
if (currentUser.UserRole == Enums.UserRole.Fleet &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.InProgress)
{
return(true);
}
if (currentUser.UserRole == Enums.UserRole.Fleet &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.Draft &&
data.VEHICLE_TYPE == "WTC")
{
return(true);
}
return(false);
}
private bool UpdateFleet(TraCrfDto data, Login loginFleet)
{
var dataFleet = _fleetService.GetFleetByParam(new FleetParamInput()
{
EmployeeId = data.EMPLOYEE_ID,
VehicleType = data.VEHICLE_TYPE,
VehicleUsage = data.VEHICLE_USAGE,
VehicleStatus = "ACTIVE",
PoliceNumber = data.POLICE_NUMBER
}).FirstOrDefault();
if (dataFleet == null)
{
return(false);
}
if (data.CHANGE_POLICE_NUMBER.HasValue && data.CHANGE_POLICE_NUMBER.Value)
{
dataFleet.POLICE_NUMBER = data.NEW_POLICE_NUMBER;
}
dataFleet.CITY = data.LOCATION_CITY_NEW;
dataFleet.MODIFIED_BY = loginFleet.USER_ID;
dataFleet.MODIFIED_DATE = DateTime.Now;
dataFleet.COST_CENTER = data.COST_CENTER_NEW;
try
{
_fleetService.save(dataFleet);
return(true);
}
catch (Exception)
{
return(false);
}
}
private void AddWorkflowHistory(TraCrfDto input, Login currentUserLogin, Enums.ActionType action, int?RemarkId)
{
var dbData = new WorkflowHistoryDto();
dbData.ACTION_BY = currentUserLogin.USER_ID;
dbData.FORM_ID = input.TRA_CRF_ID;
dbData.MODUL_ID = Enums.MenuList.TraCrf;
dbData.REMARK_ID = RemarkId;
dbData.ACTION_DATE = DateTime.Now;
dbData.ACTION = action;
dbData.REMARK_ID = RemarkId;
switch (input.DOCUMENT_STATUS)
{
case (int)Enums.DocumentStatus.AssignedForUser:
SendEmailWorkflow(input, Enums.ActionType.Submit);
break;
case (int)Enums.DocumentStatus.WaitingHRApproval:
if (action == Enums.ActionType.Approve)
{
SendEmailWorkflow(input, Enums.ActionType.Approve);
}
else if (action == Enums.ActionType.Submit)
{
SendEmailWorkflow(input, Enums.ActionType.Approve);
}
else
{
SendEmailWorkflow(input, Enums.ActionType.Reject);
}
break;
case (int)Enums.DocumentStatus.WaitingFleetApproval:
if (action == Enums.ActionType.Approve)
{
SendEmailWorkflow(input, Enums.ActionType.Approve);
}
else if (action == Enums.ActionType.Submit)
{
SendEmailWorkflow(input, Enums.ActionType.Approve);
}
else
{
SendEmailWorkflow(input, Enums.ActionType.Reject);
}
break;
case (int)Enums.DocumentStatus.InProgress:
SendEmailWorkflow(input, Enums.ActionType.Approve);
break;
}
_workflowService.Save(dbData);
}
public bool IsAllowedApprove(Login currentUser, TraCrfDto data)
{
bool isAllowed = false;
if (currentUser.UserRole == Enums.UserRole.HR &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingHRApproval)
{
return(true);
}
if (currentUser.UserRole == Enums.UserRole.Fleet &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingFleetApproval)
{
return(true);
}
return(isAllowed);
}
private void SendEmailWorkflow(TraCrfDto crfData, Enums.ActionType action)
{
//var csfData = Mapper.Map<TraCsfDto>(_CsfService.GetCsfById(input.DocumentId));
var mailProcess = ProsesMailNotificationBody(crfData, action);
//distinct double To email
List <string> ListTo = mailProcess.To.Distinct().ToList();
if (mailProcess.IsCCExist)
{
//Send email with CC
_messageService.SendEmailToListWithCC(ListTo, mailProcess.CC, mailProcess.Subject, mailProcess.Body, true);
}
else
{
_messageService.SendEmailToList(ListTo, mailProcess.Subject, mailProcess.Body, true);
}
}
private FMSMailNotification ProsesMailNotificationBody(TraCrfDto crfData, Enums.ActionType action)
{
var bodyMail = new StringBuilder();
var rc = new FMSMailNotification();
//var vehTypeBenefit = _settingService.GetSetting().Where(x => x.SETTING_GROUP == "VEHICLE_TYPE" && x.SETTING_NAME == "BENEFIT").FirstOrDefault().MST_SETTING_ID;
var isBenefit = crfData.VEHICLE_TYPE.ToUpper().Contains("BENEFIT");
string creatorDataEmail = "";
var webRootUrl = ConfigurationManager.AppSettings["WebRootUrl"];
var typeEnv = ConfigurationManager.AppSettings["Environment"];
var serverIntranet = ConfigurationManager.AppSettings["ServerIntranet"];
var employeeData = _employeeService.GetEmployeeById(crfData.EMPLOYEE_ID);
var hrList = string.Empty;
var fleetList = string.Empty;
var hrEmailList = new List <string>();
var fleetEmailList = new List <string>();
var hrRole = _settingService.GetSetting().Where(x => x.SETTING_GROUP == EnumHelper.GetDescription(Enums.SettingGroup.UserRole) &&
x.SETTING_VALUE.Contains("HR")).FirstOrDefault().SETTING_VALUE;
var fleetRole = _settingService.GetSetting().Where(x => x.SETTING_GROUP == EnumHelper.GetDescription(Enums.SettingGroup.UserRole) &&
x.SETTING_VALUE.Contains("FLEET")).FirstOrDefault().SETTING_VALUE;
var hrQuery = "SELECT 'PMI\\' + sAMAccountName AS sAMAccountName FROM OPENQUERY(ADSI, 'SELECT employeeID, sAMAccountName, displayName, name, givenName, whenCreated, whenChanged, SN, manager, distinguishedName, info FROM ''LDAP://DC=PMINTL,DC=NET'' WHERE memberOf = ''CN = " + hrRole + ", OU = ID, OU = Security, OU = IMDL Managed Groups, OU = Global, OU = Users & Workstations, DC = PMINTL, DC = NET''') ";
var fleetQuery = "SELECT 'PMI\\' + sAMAccountName AS sAMAccountName FROM OPENQUERY(ADSI, 'SELECT employeeID, sAMAccountName, displayName, name, givenName, whenCreated, whenChanged, SN, manager, distinguishedName, info FROM ''LDAP://DC=PMINTL,DC=NET'' WHERE memberOf = ''CN = " + fleetRole + ", OU = ID, OU = Security, OU = IMDL Managed Groups, OU = Global, OU = Users & Workstations, DC = PMINTL, DC = NET''') ";
if (typeEnv == "VTI")
{
hrQuery = "SELECT 'PMI\\' + LOGIN AS LOGIN FROM LOGIN_FOR_VTI WHERE AD_GROUP = '" + hrRole + "'";
fleetQuery = "SELECT 'PMI\\' + LOGIN AS LOGIN FROM LOGIN_FOR_VTI WHERE AD_GROUP = '" + fleetRole + "'";
}
EntityConnectionStringBuilder e = new EntityConnectionStringBuilder(ConfigurationManager.ConnectionStrings["FMSEntities"].ConnectionString);
string connectionString = e.ProviderConnectionString;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand query = new SqlCommand(hrQuery, con);
SqlDataReader reader = query.ExecuteReader();
while (reader.Read())
{
var hrLogin = "******" + reader[0].ToString() + "',";
hrList += hrLogin;
}
hrList = hrList.TrimEnd(',');
query = new SqlCommand(fleetQuery, con);
reader = query.ExecuteReader();
while (reader.Read())
{
var fleetLogin = "******" + reader[0].ToString() + "',";
fleetList += fleetLogin;
}
fleetList = fleetList.TrimEnd(',');
var hrQueryEmail = "SELECT EMAIL FROM " + serverIntranet + ".[dbo].[tbl_ADSI_User] WHERE FULL_NAME IN (" + hrList + ")";
var fleetQueryEmail = "SELECT EMAIL FROM " + serverIntranet + ".[dbo].[tbl_ADSI_User] WHERE FULL_NAME IN (" + fleetList + ")";
var creatorQuery =
"SELECT EMAIL from " + serverIntranet + ".[dbo].[tbl_ADSI_User] where FULL_NAME like 'PMI\\" +
crfData.CREATED_BY + "'";
if (typeEnv == "VTI")
{
hrQueryEmail = "SELECT EMAIL FROM EMAIL_FOR_VTI WHERE FULL_NAME IN (" + hrList + ")";
fleetQueryEmail = "SELECT EMAIL FROM EMAIL_FOR_VTI WHERE FULL_NAME IN (" + fleetList + ")";
creatorQuery = "SELECT EMAIL FROM LOGIN_FOR_VTI WHERE LOGIN like '" + crfData.CREATED_BY + "'";
}
query = new SqlCommand(hrQueryEmail, con);
reader = query.ExecuteReader();
while (reader.Read())
{
hrEmailList.Add(reader[0].ToString());
}
query = new SqlCommand(fleetQueryEmail, con);
reader = query.ExecuteReader();
while (reader.Read())
{
fleetEmailList.Add(reader[0].ToString());
}
query = new SqlCommand(creatorQuery, con);
reader = query.ExecuteReader();
while (reader.Read())
{
creatorDataEmail = reader["EMAIL"].ToString();
}
reader.Close();
con.Close();
var receiver = "";
var sender = "";
switch (action)
{
case Enums.ActionType.Submit:
//if submit from HR to EMPLOYEE
if (isBenefit)
{
rc.Subject = crfData.DOCUMENT_NUMBER + " - Benefit Car Relocation";
bodyMail.Append("Dear " + crfData.EMPLOYEE_NAME + ",<br />");
bodyMail.AppendLine();
bodyMail.Append("Please be advised that due to your Benefit Car entitlement and refering to “HMS 351 - Car For Manager” Principle & Practices, please select Car Model and Types by click in <a href='" + webRootUrl + "/TraCrf/Edit/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>HERE</a><br />");
bodyMail.AppendLine();
bodyMail.Append("As per your entitlement, we kindly ask you to complete the form within 14 calendar days to ensure your car will be ready on time and to avoid the consequence as stated in the P&P Car For Manager.<br />");
bodyMail.AppendLine();
bodyMail.Append("Important Information:");
bodyMail.AppendLine();
bodyMail.Append("To support you in understanding benefit car (COP/CFM) scheme, the circumstances, and other the terms and conditions, we advise you to read following HR Documents before selecting car scheme and type.<br />");
bodyMail.AppendLine();
bodyMail.Append("- P&P Car For Manager along with the attachments >> click Car for Manager, Affiliate Practices (link)<br />");
bodyMail.AppendLine();
bodyMail.Append("- Car types, models, contribution and early termination terms and conditions >> click Car Types and Models, Communication (link)<br />");
bodyMail.AppendLine();
bodyMail.Append("- Draft of COP / CFM Agreement (attached)<br />");
bodyMail.AppendLine();
bodyMail.Append("The procurement process will start after receiving the signed forms with approximately 2-3 months lead time, and may be longer depending on the car availability in vendor. Thus, during lead time of procurement, you will be using temporary car.<br />");
bodyMail.AppendLine();
bodyMail.Append("If you are interested to modify your CAR current entitlement, we encourage you to read following HR Documents regarding flexible benefits.<br />");
bodyMail.AppendLine();
bodyMail.Append("- P&P Flexible Benefit>> click Flexible Benefits Practices (link)<br />");
bodyMail.AppendLine();
bodyMail.Append("- Flexible Benefit Design >> click Flexible Benefit Design (link)<br />");
bodyMail.AppendLine();
bodyMail.Append("- Core Benefits & Allocated Flex Points Communication >> click Core Benefits & Allocated Flex Points Communication (link)<br />");
bodyMail.AppendLine();
bodyMail.Append("- Coverage Selection Communication >> click Coverage Selection Communication (link)<br />");
bodyMail.AppendLine();
bodyMail.Append("Should you need any help or have any questions, please do not hesitate to contact the HR Services team:<br />");
bodyMail.AppendLine();
bodyMail.Append("- Car for Manager : Rizal Setiansyah (ext. 21539) or Astrid Meirina (ext.67165)<br />");
bodyMail.AppendLine();
bodyMail.Append("- Flexible Benefits : HR Services at [email protected] or ext. 900<br />");
bodyMail.AppendLine();
bodyMail.Append("- Thank you for your kind attention and cooperation.<br />");
bodyMail.AppendLine();
rc.To.Add(employeeData.EMAIL_ADDRESS);
if (crfData.VEHICLE_TYPE == "BENEFIT")
{
foreach (var item in hrEmailList)
{
rc.CC.Add(item);
}
}
else
{
foreach (var item in fleetEmailList)
{
rc.CC.Add(item);
}
}
}
//if submit from FLEET to EMPLOYEE
else if (!isBenefit)
{
rc.Subject = crfData.DOCUMENT_NUMBER + " - Operational Vehicle Relocation";
bodyMail.Append("Dear " + crfData.EMPLOYEE_NAME + ",<br />");
bodyMail.AppendLine();
bodyMail.Append("new operational car has been recorded as " + crfData.DOCUMENT_NUMBER + "<br />");
bodyMail.AppendLine();
bodyMail.Append("Please submit detail vehicle information <a href='" + webRootUrl + "/TraCrf/Edit/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>HERE.</a><br />");
bodyMail.AppendLine();
bodyMail.Append("We kindly ask you to complete the form back to within 7 calendar days<br />");
bodyMail.AppendLine();
bodyMail.Append("For any assistance please contact Fleet Name<br />");
bodyMail.AppendLine();
rc.To.Add(employeeData.EMAIL_ADDRESS);
foreach (var item in fleetEmailList)
{
rc.CC.Add(item);
}
}
break;
case Enums.ActionType.Approve:
if (crfData.DOCUMENT_STATUS != (int)Enums.DocumentStatus.InProgress)
{
rc.Subject = "CRF - Request Approval";
if (crfData.VEHICLE_TYPE == "BENEFIT" &&
crfData.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingHRApproval)
{
receiver = crfData.CREATED_BY;
sender = employeeData.FORMAL_NAME;
}
else if (crfData.VEHICLE_TYPE == "BENEFIT" &&
crfData.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingFleetApproval)
{
receiver = "Fleet Team";
sender = "HR Team";
}
else
{
receiver = "Fleet Team";
sender = employeeData.FORMAL_NAME;
}
bodyMail.Append("Dear " + receiver + ",<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("You have received new car relocation request<br />");
bodyMail.AppendLine();
bodyMail.Append("Send confirmation by clicking <a href='" + webRootUrl + "/TraCrf/Edit/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>Here</a>.<br />");
bodyMail.AppendLine();
//bodyMail.Append("<a href='" + webRootUrl + "/TraCrf/Edit/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>" +
// crfData.DOCUMENT_NUMBER + "</a> requested by " + crfData.EMPLOYEE_NAME +
// "<br /><br />");
//bodyMail.AppendLine();
bodyMail.Append("Thanks<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("Regards,<br />");
bodyMail.AppendLine();
bodyMail.Append(sender);
bodyMail.AppendLine();
if (crfData.VEHICLE_TYPE == "BENEFIT" &&
crfData.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingHRApproval)
{
rc.To.Add(creatorDataEmail);
rc.CC.Add(employeeData.EMAIL_ADDRESS);
}
else
{
foreach (var item in fleetEmailList)
{
rc.To.Add(item);
}
rc.CC.Add(creatorDataEmail);
rc.CC.Add(employeeData.EMAIL_ADDRESS);
}
}
else
{
var vendorData = _vendorService.GetByShortName(crfData.VENDOR_NAME);
rc.Subject = "CRF - Relocation Request, need confirmation.";
bodyMail.Append("Dear " + vendorData.VENDOR_NAME + ",<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("Below are the details of vehicle relocation request :<br />");
bodyMail.AppendLine();
if (crfData.CHANGE_POLICE_NUMBER.HasValue && crfData.CHANGE_POLICE_NUMBER.Value)
{
bodyMail.Append(string.Format("Old Police number : {0} <br />", crfData.POLICE_NUMBER));
bodyMail.Append(string.Format("New Police number : {0} <br />", crfData.NEW_POLICE_NUMBER));
}
else
{
bodyMail.Append(string.Format("Police number : {0} <br />", crfData.POLICE_NUMBER));
}
bodyMail.AppendLine();
bodyMail.Append(string.Format("Current Location : {0} - {1} <br />", crfData.LOCATION_CITY, crfData.LOCATION_OFFICE));
bodyMail.AppendLine();
bodyMail.Append(string.Format("Destination Location : {0} - {1} <br />", crfData.LOCATION_CITY_NEW, crfData.LOCATION_OFFICE_NEW));
bodyMail.Append(string.Format("Withdrawal Date : {0} <br />", crfData.WITHD_DATETIME));
bodyMail.Append(string.Format("Expected Delivery Date : {0} <br />", crfData.EFFECTIVE_DATE));
bodyMail.AppendLine();
bodyMail.Append("Reply this email for your confirmation.");
bodyMail.AppendLine();
bodyMail.Append("Thanks<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("Regards,<br />");
bodyMail.AppendLine();
bodyMail.Append("Fleet Team");
bodyMail.AppendLine();
foreach (var item in fleetEmailList)
{
rc.CC.Add(item);
}
rc.CC.Add(creatorDataEmail);
rc.To.Add(vendorData.EMAIL_ADDRESS);
}
break;
case Enums.ActionType.Reject:
if (crfData.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingHRApproval)
{
sender = "HR Team";
receiver = employeeData.FORMAL_NAME;
rc.To.Add(employeeData.EMAIL_ADDRESS);
rc.CC.Add(creatorDataEmail);
}
if (crfData.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingFleetApproval &&
crfData.VEHICLE_TYPE == "WTC"
)
{
//foreach (var item in fleetList)
//{
// rc.CC.Add(item);
//}
sender = "Fleet Team";
receiver = employeeData.FORMAL_NAME;
rc.To.Add(employeeData.EMAIL_ADDRESS);
rc.CC.Add(creatorDataEmail);
}
if (crfData.DOCUMENT_STATUS == (int)Enums.DocumentStatus.WaitingFleetApproval &&
crfData.VEHICLE_TYPE == "BENEFIT"
)
{
foreach (var item in fleetEmailList)
{
rc.CC.Add(item);
}
rc.To.Add(creatorDataEmail);
sender = "Fleet Team";
receiver = "HR Team";
}
rc.Subject = "CRF - Request Rejected";
bodyMail.Append("Dear " + receiver + ",<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("Your car relocation request has been rejected.<br />");
bodyMail.AppendLine();
bodyMail.Append("Please fix your data and resubmit by clicking <a href='" + webRootUrl + "/TraCrf/Edit/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>Here</a>.<br />");
bodyMail.AppendLine();
//bodyMail.Append("<a href='" + webRootUrl + "/TraCrf/Edit/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>Here</a> requested by " + crfData.EMPLOYEE_NAME + "<br /><br />");
//bodyMail.AppendLine();
bodyMail.Append("Thanks<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("Regards,<br />");
bodyMail.AppendLine();
bodyMail.Append(sender);
bodyMail.AppendLine();
break;
case Enums.ActionType.Completed:
rc.Subject = "CRF - Request Completed";
bodyMail.Append("Dear " + employeeData.FORMAL_NAME + ",<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("Your car relocation request has been completed.<br />");
bodyMail.AppendLine();
bodyMail.Append("If you need to see your request reference click <a href='" + webRootUrl + "/TraCrf/Edit/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>Here</a>.<br />");
bodyMail.AppendLine();
//bodyMail.Append("<a href='" + webRootUrl + "/TraCrf/Details/" + crfData.TRA_CRF_ID + "?isPersonalDashboard=True'>Here</a> requested by " + crfData.EMPLOYEE_NAME + "<br /><br />");
//bodyMail.AppendLine();
bodyMail.Append("Thanks<br /><br />");
bodyMail.AppendLine();
bodyMail.Append("Regards,<br />");
bodyMail.AppendLine();
bodyMail.Append("Fleet Team");
bodyMail.AppendLine();
rc.To.Add(employeeData.EMAIL_ADDRESS);
rc.CC.Add(creatorDataEmail);
foreach (var item in fleetEmailList)
{
rc.CC.Add(item);
}
break;
}
rc.Body = bodyMail.ToString();
if (rc.CC.Count > 0)
{
rc.IsCCExist = true;
}
return(rc);
}
public void SubmitCrf(TraCrfDto dataSubmit, Login currentUser)
{
var data = _CrfService.GetById((int)dataSubmit.TRA_CRF_ID);
var currentDocStatus = data.DOCUMENT_STATUS;
if (currentUser.UserRole == Enums.UserRole.HR && data.VEHICLE_TYPE.ToUpper() == "BENEFIT")
{
data.DOCUMENT_STATUS = (int)Enums.DocumentStatus.AssignedForUser;
}
if (currentUser.UserRole == Enums.UserRole.Fleet &&
data.VEHICLE_TYPE.ToUpper() == "WTC" &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.Draft)
{
data.DOCUMENT_STATUS = (int)Enums.DocumentStatus.AssignedForUser;
}
var dataFleet = _fleetService.GetFleetByParam(new FleetParamInput()
{
EmployeeId = data.EMPLOYEE_ID,
VehicleType = data.VEHICLE_TYPE
}).FirstOrDefault();
if (currentUser.EMPLOYEE_ID == data.EMPLOYEE_ID &&
data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.AssignedForUser)
{
data.DELIV_ADDRESS = dataSubmit.DELIV_ADDRESS;
data.DELIV_CITY = dataSubmit.DELIV_CITY;
data.DELIV_PHONE = dataSubmit.DELIV_PHONE;
data.DELIV_PIC = dataSubmit.DELIV_PIC;
data.WITHD_ADDRESS = dataSubmit.WITHD_ADDRESS;
data.WITHD_CITY = dataSubmit.WITHD_CITY;
data.WITHD_DATETIME = dataSubmit.WITHD_DATETIME;
data.WITHD_PHONE = dataSubmit.WITHD_PHONE;
data.WITHD_PIC = dataSubmit.WITHD_PIC;
data.DOCUMENT_STATUS = (int)(data.VEHICLE_TYPE.ToUpper() == "WTC"
? Enums.DocumentStatus.WaitingFleetApproval
: Enums.DocumentStatus.WaitingHRApproval);
}
data.IS_ACTIVE = true;
data.BODY_TYPE = dataFleet != null ? dataFleet.BODY_TYPE : null;
if (dataSubmit.MST_FLEET_ID == null)
{
data.MST_FLEET_ID = dataFleet != null ? dataFleet.MST_FLEET_ID : (long?)null;
}
if (dataSubmit.DOCUMENT_STATUS == (int)Enums.DocumentStatus.InProgress)
{
if (data.EXPECTED_DATE < data.WITHD_DATETIME)
{
data.DOCUMENT_STATUS = (int)Enums.DocumentStatus.InProgress;
}
}
data.MODIFIED_BY = currentUser.USER_ID;
_CrfService.SaveCrf(data, currentUser);
var crfDto = Mapper.Map <TraCrfDto>(data);
if (currentDocStatus != data.DOCUMENT_STATUS)
{
AddWorkflowHistory(crfDto, currentUser, Enums.ActionType.Submit, null);
_uow.SaveChanges();
}
}
public TraCrfDto SaveCrf(TraCrfDto data, Login userLogin)
{
var remark = data.REMARK_ID;
data.REMARK_ID = null;
var datatosave = Mapper.Map <TRA_CRF>(data);
datatosave.BODY_TYPE = data.Body;
datatosave.MODIFIED_BY = userLogin.USER_ID;
var dataFleet = _fleetService.GetFleetByParam(new FleetParamInput()
{
EmployeeId = datatosave.EMPLOYEE_ID,
VehicleType = datatosave.VEHICLE_TYPE
}).FirstOrDefault();
if (datatosave.TRA_CRF_ID > 0)
{
}
else
{
//datatosave.role_type
datatosave.DOCUMENT_NUMBER = _docNumberService.GenerateNumber(new GenerateDocNumberInput()
{
Month = DateTime.Now.Month,
Year = DateTime.Now.Year,
DocType = (int)Enums.DocumentType.CRF
});
//datatosave.DELIV_CITY = datatosave.LOCATION_CITY;
//datatosave.DELIV_ADDRESS = datatosave.LOCATION_OFFICE;
//datatosave.WITHD_CITY = dataFleet != null ? dataFleet.CITY : null;
//datatosave.WITHD_ADDRESS = dataFleet != null ? dataFleet.ADDRESS : null;
}
if (datatosave.VEHICLE_TYPE == "WTC" || (datatosave.VEHICLE_TYPE == "BENEFIT" && datatosave.VEHICLE_USAGE == "COP"))
{
datatosave.RELOCATION_TYPE = "RELOCATE_UNIT";
}
if (data.DOCUMENT_STATUS != (int)Enums.DocumentStatus.Cancelled)
{
datatosave.MST_REMARK = null;
datatosave.REMARK = null;
}
else
{
datatosave.REMARK = remark;
_CrfService.SaveCrf(datatosave, userLogin);
return(data);
//AddWorkflowHistory(data, userLogin, Enums.ActionType.Created, null);
}
datatosave.BODY_TYPE = dataFleet != null ? dataFleet.BODY_TYPE : null;
datatosave.MST_FLEET_ID = dataFleet != null ? dataFleet.MST_FLEET_ID : (long?)null;
var isCompleted = false;
if (data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.InProgress &&
DateTime.Now >= data.EFFECTIVE_DATE)
{
if (data.PRICE != null)
{
data.DOCUMENT_STATUS = (int)Enums.DocumentStatus.Completed;
isCompleted = CompleteDocument(data.TRA_CRF_ID, userLogin);
if (isCompleted)
{
datatosave.DOCUMENT_STATUS = data.DOCUMENT_STATUS;
}
}
}
if (!data.IsSend)
{
data.TRA_CRF_ID = _CrfService.SaveCrf(datatosave, userLogin);
if (data.DOCUMENT_STATUS == (int)Enums.DocumentStatus.Draft)
{
AddWorkflowHistory(data, userLogin, Enums.ActionType.Created, null);
}
}
else
{
data.TRA_CRF_ID = _CrfService.SaveCrf(datatosave, userLogin);
//AddWorkflowHistory(data, userLogin, Enums.ActionType.Submit, null);
_uow.SaveChanges();
SubmitCrf(data, userLogin);
}
return(data);
}
public TraCrfDto AssignCrfFromEpaf(long epafId, Login CurrentUser)
{
var epafData = _epafService.GetEpafById(epafId);
if (epafData != null)
{
var existingData = _CrfService.GetByEpafId(epafId);
if (existingData != null)
{
throw new Exception("Epaf Already asigned.");
}
TraCrfDto item = new TraCrfDto();
var employeeData = _employeeService.GetEmployeeById(epafData.EMPLOYEE_ID);
var fleetData = _fleetService.GetFleetByParam(new FleetParamInput()
{
EmployeeId = employeeData.EMPLOYEE_ID,
VehicleType = "BENEFIT"
}).FirstOrDefault();
var fleetDo = Mapper.Map <FleetDto>(fleetData);
var employeeDto = Mapper.Map <EmployeeDto>(employeeData);
employeeDto.EmployeeVehicle = fleetDo;
item = Mapper.Map <TraCrfDto>(epafData);
if (CurrentUser.UserRole == Enums.UserRole.HR)
{
item.VEHICLE_TYPE = "BENEFIT";
item.COST_CENTER = employeeDto.COST_CENTER;
}
else if (CurrentUser.UserRole == Enums.UserRole.Fleet)
{
item.VEHICLE_TYPE = "WTC";
}
if (employeeData == null)
{
throw new Exception(string.Format("Employee Data {0} not found.", epafData.EMPLOYEE_ID));
}
item.LOCATION_CITY = employeeData.CITY;
item.LOCATION_OFFICE = employeeData.BASETOWN;
item.CREATED_BY = CurrentUser.USER_ID;
item.CREATED_DATE = DateTime.Now;
item.DOCUMENT_STATUS = (int)Enums.DocumentStatus.AssignedForUser;
item.IS_ACTIVE = true;
var vehicleData = _fleetService.GetFleetByParam(new FleetParamInput()
{
EmployeeId = epafData.EMPLOYEE_ID,
VehicleType = item.VEHICLE_TYPE,
}).FirstOrDefault();
if (vehicleData != null)
{
var vendorData =
_vendorService.GetVendor().FirstOrDefault(x => x.SHORT_NAME == vehicleData.VENDOR_NAME);
item.POLICE_NUMBER = vehicleData.POLICE_NUMBER;
item.MANUFACTURER = vehicleData.MANUFACTURER;
item.MODEL = vehicleData.MODEL;
item.SERIES = vehicleData.SERIES;
item.Body = vehicleData.BODY_TYPE;
item.VENDOR_NAME = vendorData != null ? vendorData.SHORT_NAME : null;
item.VENDOR_ID = vendorData != null ? vendorData.MST_VENDOR_ID : (int?)null;
item.START_PERIOD = vehicleData.START_CONTRACT;
item.END_PERIOD = vehicleData.END_CONTRACT;
item.VEHICLE_TYPE = vehicleData.VEHICLE_TYPE;
item.VEHICLE_USAGE = vehicleData.VEHICLE_USAGE;
item.MST_FLEET_ID = vehicleData.MST_FLEET_ID;
item.WITHD_CITY = vehicleData.CITY;
item.WITHD_ADDRESS = vehicleData.ADDRESS;
}
else
{
throw new Exception("Vehicle for this employee not found on FMS.");
}
item.DELIV_CITY = epafData.CITY;
item.DELIV_ADDRESS = epafData.BASE_TOWN;
var returnData = this.SaveCrf(item, CurrentUser);
AddWorkflowHistory(returnData, CurrentUser, Enums.ActionType.Submit, null);
return(returnData);
}
else
{
throw new Exception("Please select Epaf document first.");
}
}