public async Task <ApiResponse> Handle(DeleteDocumentDetailCommand request, CancellationToken cancellationToken)
{
ApiResponse response = new ApiResponse();
try
{
EmployeeDocumentDetail documentinfo = await _dbContext.EmployeeDocumentDetail.FirstOrDefaultAsync(x => x.DocumentID == request.DocumentId &&
x.IsDeleted == false);
if (documentinfo != null)
{
documentinfo.IsDeleted = true;
documentinfo.ModifiedById = request.ModifiedById;
documentinfo.ModifiedDate = DateTime.UtcNow;
await _dbContext.SaveChangesAsync();
response.StatusCode = StaticResource.failStatusCode;
response.Message = "Success";
}
}
catch (Exception ex)
{
response.StatusCode = StaticResource.failStatusCode;
response.Message = ex.Message;
}
return(response);
}
public ActionResult EmployeeDocumentsEdit(int id)
{
EmployeeDocumentDetail documentInDb = _context.EmployeeDocumentDetails.Where(x => x.document_id == id).FirstOrDefault();
if (documentInDb == null)
{
ModelState.AddModelError("", "Not found.");
return(View("EmployeeDocumentForm", documentInDb));
}
EmployeeDocumentFormViewModel viewModel = new EmployeeDocumentFormViewModel
{
document_id = documentInDb.document_id,
type = documentInDb.type,
name = documentInDb.name,
number = documentInDb.number,
birthdate = documentInDb.birthdate,
address = documentInDb.address,
employee_id = int.Parse(Session["EmployeeId"].ToString()),
DocTypes = ManageDependancyData.DocumentTypes(),
Title = "Edit Document"
};
return(View("EmployeeDocumentForm", viewModel));
}
public void Delete(EmployeeDocumentDetail entity)
{
try
{
empDocDetailService.Delete(entity);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddClaimDocuments(EmployeeDocumentDetail entity)
{
try
{
empDocDetailService.AddClaimDocuments(entity);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult EmployeeDocumentsDelete(int id)
{
EmployeeDocumentDetail documentInDb = _context.EmployeeDocumentDetails.Where(x => x.document_id == id).FirstOrDefault();
if (documentInDb == null)
{
ModelState.AddModelError("", "Not found.");
return(View("EmployeeDocumentForm", documentInDb));
}
_context.EmployeeDocumentDetails.Remove(documentInDb);
_context.SaveChanges();
return(RedirectToAction("EmployeeDocumentsIndex",
new { employee_id = int.Parse(Session["EmployeeId"].ToString()) }));
}
public ActionResult EmployeeDocumentsSave(EmployeeDocumentFormViewModel viewModel)
{
if (!ModelState.IsValid)
{
return(View("EmployeeDocumentForm", viewModel));
}
if (viewModel.document_id == 0)
{
EmployeeDocumentDetail document = new EmployeeDocumentDetail
{
type = viewModel.type,
name = viewModel.name,
number = viewModel.number,
birthdate = viewModel.birthdate,
address = viewModel.address,
employee_id = int.Parse(Session["EmployeeId"].ToString())
};
_context.EmployeeDocumentDetails.Add(document);
_context.SaveChanges();
}
else
{
EmployeeDocumentDetail documentInDb = _context.EmployeeDocumentDetails.Where(x => x.document_id == viewModel.document_id).FirstOrDefault();
if (documentInDb == null)
{
ModelState.AddModelError("", "Bad request.");
return(View("EmployeeDocumentForm", viewModel));
}
documentInDb.type = viewModel.type;
documentInDb.name = viewModel.name;
documentInDb.number = viewModel.number;
documentInDb.birthdate = viewModel.birthdate;
documentInDb.address = viewModel.address;
_context.Entry(documentInDb).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
}
return(RedirectToAction("EmployeeDocumentsIndex",
new { employee_id = int.Parse(Session["EmployeeId"].ToString()) }));
}
public async Task <ApiResponse> Handle(AddDocumentDetailCommand request, CancellationToken cancellationToken)
{
ApiResponse response = new ApiResponse();
try
{
byte[] filepathBase64 = Encoding.UTF8.GetBytes(request.FilePath);
string[] str = request.FilePath.Split(",");
byte[] filepath = Convert.FromBase64String(str[1]);
string ex = str[0].Split("/")[1].Split(";")[0];
string guidname = Guid.NewGuid().ToString();
string filename = guidname + "." + ex;
File.WriteAllBytes(@"Documents/" + filename, filepath); // Document path for server
EmployeeDocumentDetail obj = new EmployeeDocumentDetail
{
DocumentGUID = guidname,
//Doctype 1 for voucher document
DocumentType = request.DocumentType,
Extension = "." + ex,
DocumentName = request.DocumentName,
DocumentDate = request.DocumentDate,
EmployeeID = request.EmployeeID,
CreatedById = request.CreatedById,
CreatedDate = DateTime.UtcNow,
IsDeleted = false
};
await _dbContext.EmployeeDocumentDetail.AddAsync(obj);
await _dbContext.SaveChangesAsync();
response.StatusCode = StaticResource.successStatusCode;
response.Message = "Success";
}
catch (Exception ex)
{
response.StatusCode = StaticResource.failStatusCode;
response.Message = ex.Message;
}
return(response);
}
public void SaveEmployeeVm(EmployeeVm empVm)
{
if (empVm.empHeader.EmployeeId == -1)
{
var empHeader = new EmployeeHeader()
{
BranchId = sessionObj.BRANCHID,
FirstName = empVm.empHeader.FirstName,
MiddleName = empVm.empHeader.MiddleName,
LastName = empVm.empHeader.LastName,
Nationality = empVm.empHeader.Nationality,
IDType = empVm.empHeader.IDType,
IDNumber = "",
UserEmailId = empVm.empHeader.UserEmailId,
Password = empVm.empHeader.Password,
ConfirmPassword = empVm.empHeader.ConfirmPassword,
IsActive = true,
CreatedBy = sessionObj.USERID,
CreatedOn = UTILITY.SINGAPORETIME,
ModifiedBy = sessionObj.USERID,
ModifiedOn = UTILITY.SINGAPORETIME,
ManagerId = empVm.empHeader.ManagerId,
IsReportingAuthority = empVm.empHeader.IsReportingAuthority,
SalutationType = empVm.empHeader.SalutationType
};
Add(empHeader);
empVm.empHeader.EmployeeId = empHeader.EmployeeId;
var empPersonalDetail = new EmployeePersonalDetail
{
EmployeeId = empVm.empHeader.EmployeeId,
BranchId = sessionObj.BRANCHID,
DOB = empVm.empPersonalDetail.DOB,
Gender = empVm.empPersonalDetail.Gender, //
BirthCountry = empVm.empPersonalDetail.BirthCountry, //
CitizenshipCountry = "", //
FatherName = empVm.empPersonalDetail.FatherName,
MaritalStatus = empVm.empPersonalDetail.MaritalStatus,
SpouseName = empVm.empPersonalDetail.SpouseName, //
EmergencyContactName = empVm.empPersonalDetail.EmergencyContactName,
EmergencyContactNumber = empVm.empPersonalDetail.EmergencyContactNumber,
MarriageDate = empVm.empPersonalDetail.MarriageDate, //
ResidentialStatus = empVm.empPersonalDetail.ResidentialStatus, //
CreatedBy = sessionObj.USERID,
CreatedOn = UTILITY.SINGAPORETIME,
ModifiedBy = sessionObj.USERID,
ModifiedOn = UTILITY.SINGAPORETIME,
EPFNO = empVm.empPersonalDetail.EPFNO,
PasspostNo = empVm.empPersonalDetail.PasspostNo,
SocialWelfareNo = empVm.empPersonalDetail.SocialWelfareNo
};
empPersonalDetailBO.Add(empPersonalDetail);
var empWorkDetail = new EmployeeWorkDetail
{
BranchId = sessionObj.BRANCHID,
JoiningDate = empVm.empWorkDetail.JoiningDate,
ConfirmationDate = empVm.empWorkDetail.ConfirmationDate,
ProbationPeriod = empVm.empWorkDetail.ProbationPeriod,
NoticePeriod = empVm.empWorkDetail.NoticePeriod,
DesignationId = empVm.empWorkDetail.DesignationId,
DepartmentId = empVm.empWorkDetail.DepartmentId,
ResignationDate = empVm.empWorkDetail.ResignationDate,
CreatedBy = sessionObj.USERID,
CreatedOn = UTILITY.SINGAPORETIME,
ModifiedBy = sessionObj.USERID,
ModifiedOn = UTILITY.SINGAPORETIME,
EmployeeId = empVm.empHeader.EmployeeId,
SendMailsTo = empVm.empWorkDetail.SendMailsTo,
};
empWorkDetailBO.Add(empWorkDetail);
var empAddress = new Address
{
LinkID = empHeader.EmployeeId,
BranchId = sessionObj.BRANCHID,
Address1 = empVm.address.Address1,
Address2 = empVm.address.Address2,
SeqNo = 0, //
CityName = empVm.address.CityName,
StateName = empVm.address.StateName,
ZipCode = empVm.address.ZipCode,
MobileNo = empVm.address.MobileNo,
CountryCode = empHeader.Nationality,
AddressType = UTILITY.EMPLOYEE,
Contact = empVm.address.MobileNo,
Email = empHeader.UserEmailId,
IsActive = true,
CreatedBy = sessionObj.USERID,
CreatedOn = UTILITY.SINGAPORETIME,
ModifiedBy = sessionObj.USERID,
ModifiedOn = UTILITY.SINGAPORETIME
};
addressBO.Add(empAddress);
var empbankdetail = new EmployeeBankdetail
{
EmployeeId = empHeader.EmployeeId,
BranchId = sessionObj.BRANCHID,
BankName = empVm.empBankdetail.BankName,
AccountNo = empVm.empBankdetail.AccountNo,
AccountType = empVm.empBankdetail.AccountType,
BankBranchCode = empVm.empBankdetail.BankBranchCode,
SwiftCode = empVm.empBankdetail.SwiftCode
};
empbankdetailBO.Add(empbankdetail);
foreach (var item in empVm.ListAssignLeaves)
{
var empleavepolicy = new EmployeeLeavePolicy
{
BranchID = sessionObj.BRANCHID,
LeaveYear = Convert.ToInt16(DateTime.Now.Year),
EmployeeID = empHeader.EmployeeId,
LeaveTypeID = item.LeaveTypeID,
LeavesPerYear = item.LeavesPerYear,
CarryForwardLeaves = 0,
TotalLeaves = item.LeavesPerYear,
BalanceLeaves = item.LeavesPerYear
};
employeeleavepolicyBo.Add(empleavepolicy);
}
foreach (var item in empVm.empDocument)
{
if (item.Document != null && item.Document.ContentLength > 0)
{
var uidDocument = new EmployeeDocumentDetail
{
EmployeeId = empHeader.EmployeeId,
BranchId = sessionObj.BRANCHID,
DocumentType = item.DocumentType,
FileName = item.Document.FileName,
CreatedBy = sessionObj.USERID,
CreatedOn = UTILITY.SINGAPORETIME
};
empDocDetailBO.Add(uidDocument);
string path = HttpContext.Current.Server.
MapPath("~/Uploads/" + empHeader.EmployeeId + "/" + uidDocument.DocumentDetailID + "/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
item.Document.SaveAs(path + item.Document.FileName);
}
}
}
else
{
empVm.empHeader.IsActive = true;
empVm.empHeader.CreatedBy = sessionObj.USERID;
empVm.empHeader.CreatedOn = UTILITY.SINGAPORETIME;
empVm.empHeader.ModifiedBy = sessionObj.USERID;
empVm.empHeader.ModifiedOn = UTILITY.SINGAPORETIME;
Add(empVm.empHeader);
empVm.empPersonalDetail.CreatedBy = sessionObj.USERID;
empVm.empPersonalDetail.CreatedOn = UTILITY.SINGAPORETIME;
empVm.empPersonalDetail.ModifiedBy = sessionObj.USERID;
empVm.empPersonalDetail.ModifiedOn = UTILITY.SINGAPORETIME;
empVm.empPersonalDetail.BranchId = empVm.empHeader.BranchId;
empPersonalDetailBO.Add(empVm.empPersonalDetail);
empVm.empWorkDetail.CreatedBy = sessionObj.USERID;
empVm.empWorkDetail.CreatedOn = UTILITY.SINGAPORETIME;
empVm.empWorkDetail.ModifiedBy = sessionObj.USERID;
empVm.empWorkDetail.ModifiedOn = UTILITY.SINGAPORETIME;
empVm.empWorkDetail.BranchId = empVm.empHeader.BranchId;
empWorkDetailBO.Add(empVm.empWorkDetail);
empVm.address.CreatedBy = sessionObj.USERID;
empVm.address.CreatedOn = UTILITY.SINGAPORETIME;
empVm.address.ModifiedBy = sessionObj.USERID;
empVm.address.ModifiedOn = UTILITY.SINGAPORETIME;
empVm.address.LinkID = empVm.empHeader.EmployeeId;
empVm.address.AddressType = "Employee";
empVm.address.Contact = empVm.address.MobileNo;
empVm.address.Email = empVm.empHeader.UserEmailId;
empVm.address.BranchId = empVm.empHeader.BranchId;
addressBO.Add(empVm.address);
empVm.empBankdetail.AccountNo = empVm.empBankdetail.AccountNo;
empVm.empBankdetail.AccountType = empVm.empBankdetail.AccountType;
empVm.empBankdetail.BankBranchCode = empVm.empBankdetail.BankBranchCode;
empVm.empBankdetail.BankName = empVm.empBankdetail.BankName;
empVm.empBankdetail.SwiftCode = empVm.empBankdetail.SwiftCode;
empVm.empBankdetail.EmployeeId = empVm.empHeader.EmployeeId;
empVm.empBankdetail.BranchId = empVm.empHeader.BranchId;
empbankdetailBO.Add(empVm.empBankdetail);
foreach (var item in empVm.empDocument)
{
if (item.Document != null && item.Document.ContentLength > 0)
{
var uidDocument = new EmployeeDocumentDetail
{
EmployeeId = empVm.empHeader.EmployeeId,
BranchId = sessionObj.BRANCHID,
DocumentDetailID = item.DocumentDetailId,
DocumentType = item.DocumentType,
FileName = item.Document.FileName,
CreatedBy = sessionObj.USERID,
CreatedOn = UTILITY.SINGAPORETIME
};
empDocDetailBO.Add(uidDocument);
string path = HttpContext.Current.Server.MapPath("~/Uploads/" + empVm.empHeader.EmployeeId + "/" + uidDocument.DocumentDetailID + "/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
item.Document.SaveAs(path + item.Document.FileName);
}
}
}
}
