private ResultDto InsertUpdateEmployeeKYC(EmployeeKYCDto employeeKYCDto)
{
ResultDto resultDto = new ResultDto();
string objectName = "EmployeeKYC";
try
{
ObjectParameter prmEmployeeKYCID = new ObjectParameter("EmployeeKYCID", employeeKYCDto.EmployeeKYCID);
int count = _dbContext.uspEmployeeKYCInsertUpdate(prmEmployeeKYCID, employeeKYCDto.EmployeeID, employeeKYCDto.KYCType, employeeKYCDto.KYCNumber, employeeKYCDto.FileName, employeeKYCDto.ActualFileName, employeeKYCDto.StatusID, employeeKYCDto.UserID);
resultDto.ObjectId = (int)prmEmployeeKYCID.Value;
//resultDto.ObjectCode = string.IsNullOrEmpty((string)prmMandalCode.Value) ? mandalDto.MandalCode : (string)prmMandalCode.Value;
if (resultDto.ObjectId > 0)
{
resultDto.Message = string.Format("{0} details saved successfully ", objectName);
}
else if (resultDto.ObjectId == -1)
{
resultDto.Message = string.Format("Error occured while generating {0} code", objectName);
}
else
{
resultDto.Message = string.Format("Error occured while saving {0} details", objectName);
}
}
catch (Exception)
{
resultDto.Message = string.Format("Service layer error occured while saving the {0} details", objectName);
resultDto.ObjectId = -98;
}
return(resultDto);
}
public void FillEmployeeKYC(ref EmployeeModel employeeModel)
{
List <EmployeeKYCDto> objEmployeekyc = new List <EmployeeKYCDto>();
if (employeeModel.EmployeeID > 0)
{
objEmployeekyc = _employeeKycService.GetByEmployeeID(employeeModel.EmployeeID);
}
if (objEmployeekyc != null && objEmployeekyc.Count > 0)
{
List <ReferenceValueDto> kycTypeRefereces = _referenceValueService.GetByRefMasterCode(Enums.RefMasterCodes.KYCTYPE.ToString());
//Fill Employee Model With Kyc Aadhar details
var aarharType = (kycTypeRefereces.Find(k => k.RefCode.ToUpper() == Utilities.Enums.KycType.AADHAR.ToString()));
EmployeeKYCDto AadharKYC = objEmployeekyc.Find(a => a.KYCType == aarharType.RefID);
if (AadharKYC != null)
{
employeeModel.AadharNo = AadharKYC.KYCNumber;
employeeModel.AadharImagePath = AadharKYC.FileName;
}
//Fill Employee Model With Kyc PAN details
var panType = (kycTypeRefereces.Find(k => k.RefCode.ToUpper() == Utilities.Enums.KycType.PAN.ToString()));
EmployeeKYCDto panKYC = objEmployeekyc.Find(a => a.KYCType == panType.RefID);
if (panKYC != null)
{
employeeModel.PANNo = panKYC.KYCNumber;
employeeModel.PANImagePath = panKYC.FileName;
}
//Fill Employee Model With Kyc Voter details
var voterType = (kycTypeRefereces.Find(k => k.RefCode.ToUpper() == Utilities.Enums.KycType.VOTERID.ToString()));
EmployeeKYCDto voterKYC = objEmployeekyc.Find(a => a.KYCType == voterType.RefID);
if (voterKYC != null)
{
employeeModel.VoterNo = voterKYC.KYCNumber;
employeeModel.VoterImagePath = voterKYC.FileName;
}
//Fill Employee Model With Kyc Ration details
var rationType = (kycTypeRefereces.Find(k => k.RefCode.ToUpper() == Utilities.Enums.KycType.RATIONCARD.ToString()));
EmployeeKYCDto rationKYC = objEmployeekyc.Find(a => a.KYCType == rationType.RefID);
if (rationKYC != null)
{
employeeModel.RationNo = rationKYC.KYCNumber;
employeeModel.RationImagePath = rationKYC.FileName;
}
//Fill Employee Model With Kyc Ration details
var bankaccountType = (kycTypeRefereces.Find(k => k.RefCode.ToUpper() == Utilities.Enums.KycType.BANKACCOUNT.ToString()));
EmployeeKYCDto bankKYC = objEmployeekyc.Find(a => a.KYCType == bankaccountType.RefID);
if (bankKYC != null)
{
employeeModel.BankAccountNo = bankKYC.KYCNumber;
employeeModel.BankImagePath = bankKYC.FileName;
}
}
}
public EmployeeKYCDto GetByKycID(int employeekycId)
{
var objuspEmployeeKYCGetByEmployeeKYCIDResult = _dbContext.uspEmployeeKYCGetByEmployeeKYCID(employeekycId).ToList().FirstOrDefault();
EmployeeKYCDto objEmployeeKYCDto = AutoMapperEntityConfiguration.Cast <EmployeeKYCDto>(objuspEmployeeKYCGetByEmployeeKYCIDResult);
return(objEmployeeKYCDto);
}
public List <EmployeeKYCDto> GetByEmployeeID(int employeeId)
{
var objuspEmployeeKYCGetByEmployeeIDResult = _dbContext.uspEmployeeKYCGetByEmployeeID(employeeId).ToList();
List <EmployeeKYCDto> lstEmployeeKYCDto = new List <EmployeeKYCDto>();
foreach (var kyc in objuspEmployeeKYCGetByEmployeeIDResult)
{
EmployeeKYCDto objEmployeeKYCDto = Mapper.Map <uspEmployeeKYCGetByEmployeeID_Result, EmployeeKYCDto>(kyc);
lstEmployeeKYCDto.Add(objEmployeeKYCDto);
}
return(lstEmployeeKYCDto);
}
public EmployeeViewDto GetViewById(int employeeId)
{
List <uspEmployeeGetViewByID_Result> lstuspEmployeeGetViewByID_Result = _dbContext.uspEmployeeGetViewByID(employeeId).ToList();
EmployeeViewDto employeeViewDto = new EmployeeViewDto();
employeeViewDto = Mapper.Map <uspEmployeeGetViewByID_Result, EmployeeViewDto>(lstuspEmployeeGetViewByID_Result.FirstOrDefault());
List <EmployeeKYCDto> lstEmployeeKYCDto = new List <EmployeeKYCDto>();
List <uspEmployeeKYCGetViewByID_Result> lstuspEmployeeKYCGetViewByID_Result = _dbContext.uspEmployeeKYCGetViewByID(employeeId).ToList();
foreach (var Item in lstuspEmployeeKYCGetViewByID_Result)
{
EmployeeKYCDto objEmployeeKYCDto = new EmployeeKYCDto();
objEmployeeKYCDto.EmployeeID = Item.EmployeeID;
objEmployeeKYCDto.KYCNumber = Item.KYCNumber;
objEmployeeKYCDto.FileName = Item.FileName;
lstEmployeeKYCDto.Add(objEmployeeKYCDto);
}
employeeViewDto.EmployeeKYC = lstEmployeeKYCDto;
return(employeeViewDto);
}
public EmployeeKYCDto SaveKYC(HttpPostedFileBase file, int employeeId, int refid, string KYCNumber, int EmployeeKYCID)
{
string directoryPath = "AssetUploads/Employee/" + employeeId;
if (!Directory.Exists(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, directoryPath)))
{
Directory.CreateDirectory(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, directoryPath));
}
string guid = Guid.NewGuid().ToString();
string extension = Path.GetExtension(file.FileName);
string fullFileName = directoryPath + '/' + guid + extension;
file.SaveAs(AppDomain.CurrentDomain.BaseDirectory + "/" + fullFileName);
EmployeeKYCDto objEmployeeKYCDto = new EmployeeKYCDto()
{
EmployeeID = employeeId,
EmployeeKYCID = EmployeeKYCID,
KYCNumber = KYCNumber,
KYCType = refid,
FileName = fullFileName,
ActualFileName = Path.GetFileName(file.FileName),
UserID = UserInfo.UserID
};
_employeeKycService.Insert(objEmployeeKYCDto);
if (objEmployeeKYCDto.EmployeeKYCID > 0)
{
_employeeKycService.Update(objEmployeeKYCDto);
}
else
{
_employeeKycService.Insert(objEmployeeKYCDto);
}
return(objEmployeeKYCDto);
}
public ActionResult CreateEmployee(EmployeeModel empModel, List <HttpPostedFileBase> fileUpload, FormCollection form)
{
string CurrentTab = Request.Form.Get("CurrentTab");
ViewBag.CurrentTab = CurrentTab;
var resultDto = new ResultDto();
EmployeeDto objEmployeeDto = new EmployeeDto();
EmployeeModel fileModelTemp = new EmployeeModel();
#region DropDowns
List <BranchDto> BranchDto = _branchService.GetAll();
ViewBag.BranchCode = new SelectList(BranchDto, "BranchID", "BranchCode", "Select BranchCode");
List <ClusterDto> clusterSelectList = _ClusterService.GetAll();
SelectList lStClusters = new SelectList(clusterSelectList, "ClusterID", "ClusterName", objEmployeeDto.ClusterID);
ViewBag.clusters = lStClusters;
SelectList educationQualification = GetDropDownListByMasterCode(Enums.RefMasterCodes.EDUCATION_QUALIFICATION);
ViewBag.educationQualification = educationQualification;
SelectList socialCategory = GetDropDownListByMasterCode(Enums.RefMasterCodes.SOCIAL_CATEGORY);
ViewBag.socialCategory = socialCategory;
SelectList bankName = GetDropDownListByMasterCode(Enums.RefMasterCodes.BANK_NAME);
ViewBag.bankName = bankName;
SelectList AccountType = GetDropDownListByMasterCode(Enums.RefMasterCodes.BANK_ACCOUNT_TYPE);
ViewBag.AhType = AccountType;
SelectList Religion = GetDropDownListByMasterCode(Enums.RefMasterCodes.RELIGION);
ViewBag.Religion = Religion;
SelectList Desigination = GetDropDownListByMasterCode(Enums.RefMasterCodes.DESIGNATION);
ViewBag.Desigination = Desigination;
SelectList BloodGroup = GetDropDownListByMasterCode(Enums.RefMasterCodes.BLOODGROUP);
ViewBag.BloodGroup = BloodGroup;
SelectList nomineeRelationship = GetDropDownListByMasterCode(Enums.RefMasterCodes.NOMINEE_RELATIONSHIP);
ViewBag.nomineeRelationship = nomineeRelationship;
SelectList parentGuardionRelationship = GetDropDownListByMasterCode(Enums.RefMasterCodes.PARENT_GUARDIAN_RELATIONSHIP);
ViewBag.parentGuardionRelationship = parentGuardionRelationship;
ViewBag.familyIncome = GetDropDownListByMasterCode(Enums.RefMasterCodes.MONTHLY_INCOME);
var roleSelectListDto = _employeeService.GetRoleSelectList();
var roleSelectList = new SelectList(roleSelectListDto, "ID", "Text", objEmployeeDto.RoleId);
ViewBag.roles = roleSelectList;
#endregion DropDowns
EmployeeDto empDto = new EmployeeDto();
if (CurrentTab.ToUpper() == Enums.MemberTabs.PERSONALDETAILS.ToString().ToUpper())
{
string directoryPath = "AssetUploads/Employee/" + empModel.EmployeeID;
if (!Directory.Exists(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, directoryPath)))
{
Directory.CreateDirectory(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, directoryPath));
}
var file = Request.Files["Photo"];
if (file != null && file.FileName != string.Empty)
{
string guid = Guid.NewGuid().ToString();
string extension = Path.GetExtension(file.FileName);
string fullFileName = directoryPath + "/" + guid + extension;
file.SaveAs(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, fullFileName));
empModel.Photo = fullFileName;
}
else
{
empModel.Photo = Request.Form["hdnPhoto"];
}
empDto = Mapper.Map <EmployeeModel, EmployeeDto>(empModel);
empDto.Disability = Convert.ToBoolean(form["optionsRadios"]);
empDto.UserID = UserInfo.UserID;
if (empDto.EmployeeID == 0)
{
resultDto = _employeeService.Insert(empDto);
}
else
{
resultDto = _employeeService.Update(empDto);
}
}
else if (CurrentTab.ToUpper() == Enums.MemberTabs.FAMILYDETAILS.ToString().ToUpper())
{
empDto = Mapper.Map <EmployeeModel, EmployeeDto>(empModel);
empDto.UserID = UserInfo.UserID;
resultDto = _employeeService.UpdateFamily(empDto);
resultDto.ObjectCode = empModel.EmployeeCode;
}
else if (CurrentTab.ToUpper() == Enums.MemberTabs.PROOFS.ToString().ToUpper())
{
#region FileUploads
List <EmployeeKYCDto> lstKyc = new List <EmployeeKYCDto>();
EmployeeKYCDto objkycempdto = new EmployeeKYCDto();
lstKyc = _employeeKycService.GetByEmployeeID(empModel.EmployeeID);
List <ReferenceValueDto> lstReferenceValueDto = _referenceValueService.GetByRefMasterCode(Enums.RefMasterCodes.KYCTYPE.ToString());
//Aa
var aadharref = lstReferenceValueDto.Find(l => l.RefCode.ToUpper() == Enums.KycType.AADHAR.ToString().ToUpper());
var fileAadhar = Request.Files["fileAadhar"];
if (fileAadhar != null && fileAadhar.ContentLength > 0)
{
objkycempdto.KYCNumber = !string.IsNullOrEmpty(Request.Form["AADHAR"]) ? Request.Form["AADHAR"] : "";
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == aadharref.RefID) != null)
{
objkycempdto.EmployeeKYCID = lstKyc.Find(f => f.KYCType == aadharref.RefID).EmployeeKYCID;
}
EmployeeKYCDto obj = SaveKYC(fileAadhar, empModel.EmployeeID, aadharref.RefID, objkycempdto.KYCNumber, objkycempdto.EmployeeKYCID);
fileModelTemp.AadharImagePath = obj.FileName;
fileModelTemp.AadharNo = obj.KYCNumber;
}
else
{
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == aadharref.RefID) != null)
{
EmployeeKYCDto obj = lstKyc.Find(f => f.KYCType == aadharref.RefID);
fileModelTemp.AadharImagePath = obj.FileName;
fileModelTemp.AadharNo = obj.KYCNumber;
}
}
//vo
var voterref = lstReferenceValueDto.Find(l => l.RefCode.ToUpper() == Enums.KycType.VOTERID.ToString().ToUpper());
var fileVoter = Request.Files["fileVoter"];
if (fileVoter != null && fileVoter.ContentLength > 0)
{
objkycempdto.KYCNumber = !string.IsNullOrEmpty(Request.Form["VoterID"]) ? Request.Form["VoterID"] : "";
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == voterref.RefID) != null)
{
objkycempdto.EmployeeKYCID = lstKyc.Find(f => f.KYCType == voterref.RefID).EmployeeKYCID;
}
EmployeeKYCDto obj = SaveKYC(fileVoter, empModel.EmployeeID, voterref.RefID, objkycempdto.KYCNumber, objkycempdto.EmployeeKYCID);
fileModelTemp.VoterImagePath = obj.FileName;
fileModelTemp.VoterNo = obj.KYCNumber;
}
else
{
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == voterref.RefID) != null)
{
EmployeeKYCDto obj = lstKyc.Find(f => f.KYCType == voterref.RefID);
fileModelTemp.VoterImagePath = obj.FileName;
fileModelTemp.VoterNo = obj.KYCNumber;
}
}
//pan
var panref = lstReferenceValueDto.Find(l => l.RefCode.ToUpper() == Enums.KycType.PAN.ToString().ToUpper());
var filepan = Request.Files["filePan"];
if (filepan != null && filepan.ContentLength > 0)
{
objkycempdto.KYCNumber = !string.IsNullOrEmpty(Request.Form["PANCard"]) ? Request.Form["PANCard"] : "";
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == panref.RefID) != null)
{
objkycempdto.EmployeeKYCID = lstKyc.Find(f => f.KYCType == panref.RefID).EmployeeKYCID;
}
EmployeeKYCDto obj = SaveKYC(filepan, empModel.EmployeeID, panref.RefID, objkycempdto.KYCNumber, objkycempdto.EmployeeKYCID);
fileModelTemp.PANImagePath = obj.FileName;
fileModelTemp.PANNo = obj.KYCNumber;
}
else
{
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == panref.RefID) != null)
{
EmployeeKYCDto obj = lstKyc.Find(f => f.KYCType == panref.RefID);
fileModelTemp.PANImagePath = obj.FileName;
fileModelTemp.PANNo = obj.KYCNumber;
}
}
//Ration
var rationref = lstReferenceValueDto.Find(l => l.RefCode.ToUpper() == Enums.KycType.RATIONCARD.ToString().ToUpper());
var fileration = Request.Files["fileRation"];
if (fileration != null && fileration.ContentLength > 0)
{
objkycempdto.KYCNumber = !string.IsNullOrEmpty(Request.Form["RationCard"]) ? Request.Form["RationCard"] : "";
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == rationref.RefID) != null)
{
objkycempdto.EmployeeKYCID = lstKyc.Find(f => f.KYCType == rationref.RefID).EmployeeKYCID;
}
EmployeeKYCDto obj = SaveKYC(fileration, empModel.EmployeeID, rationref.RefID, objkycempdto.KYCNumber, objkycempdto.EmployeeKYCID);
fileModelTemp.RationImagePath = obj.FileName;
fileModelTemp.RationNo = obj.KYCNumber;
}
else
{
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == rationref.RefID) != null)
{
EmployeeKYCDto obj = lstKyc.Find(f => f.KYCType == rationref.RefID);
fileModelTemp.RationImagePath = obj.FileName;
fileModelTemp.RationNo = obj.KYCNumber;
}
}
//Bankaccount
var bankaccountref = lstReferenceValueDto.Find(l => l.RefCode.ToUpper() == Enums.KycType.BANKACCOUNT.ToString().ToUpper());
var filebank = Request.Files["fileBankaccount"];
if (filebank != null && filebank.ContentLength > 0)
{
objkycempdto.KYCNumber = !string.IsNullOrEmpty(Request.Form["BankAccount"]) ? Request.Form["BankAccount"] : "";
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == bankaccountref.RefID) != null)
{
objkycempdto.EmployeeKYCID = lstKyc.Find(f => f.KYCType == bankaccountref.RefID).EmployeeKYCID;
}
EmployeeKYCDto obj = SaveKYC(filebank, empModel.EmployeeID, bankaccountref.RefID, objkycempdto.KYCNumber, objkycempdto.EmployeeKYCID);
fileModelTemp.BankImagePath = obj.FileName;
fileModelTemp.BankAccountNo = obj.KYCNumber;
}
else
{
if (lstKyc != null && lstKyc.Count > 0 && lstKyc.Find(f => f.KYCType == bankaccountref.RefID) != null)
{
EmployeeKYCDto obj = lstKyc.Find(f => f.KYCType == bankaccountref.RefID);
fileModelTemp.BankImagePath = obj.FileName;
fileModelTemp.BankAccountNo = obj.KYCNumber;
}
}
#endregion FileUploads
resultDto.Message = "Employee KYC data saved successfully for Employee code : " + empModel.EmployeeCode;
resultDto.ObjectId = empModel.EmployeeID;
resultDto.ObjectCode = empModel.EmployeeCode;
}
else if (CurrentTab.ToUpper() == Enums.Employeetabs.BANKAccountDetails.ToString().ToUpper())
{
List <BankMasterDto> lstBanks = GetBanksList(form);
int employeeId = Convert.ToInt32(Request.Form["hdnObjectID"]);
ResultDto resultdto = _commonService.InsertBankDetails(employeeId, Enums.EntityCodes.EMPLOYEE, UserInfo.UserID, lstBanks);
resultDto.Message = resultdto.ObjectId > 0 ? "Employee bank details saved successfully for Employee code : " + empModel.EmployeeCode : resultdto.Message;
resultDto.ObjectId = empModel.EmployeeID;
resultDto.ObjectCode = empModel.EmployeeCode;
}
else if (CurrentTab.ToUpper() == Enums.Employeetabs.CreateLogin.ToString().ToUpper())
{
empDto = Mapper.Map <EmployeeModel, EmployeeDto>(empModel);
empDto.UserID = UserInfo.UserID;
resultDto = _employeeService.UpdateLoginDetails(empDto);
resultDto.ObjectCode = empModel.EmployeeCode;
}
if (resultDto.ObjectId > 0)
{
empDto = _employeeService.GetByID(resultDto.ObjectId);
empModel = Mapper.Map <EmployeeDto, EmployeeModel>(empDto);
resultDto.ObjectCode = empDto.EmployeeCode;
resultDto.ObjectId = empDto.EmployeeID;
//REFILL THE KYC
FillEmployeeKYC(ref empModel);
//REFILL THE BANKS
}
ViewBag.Result = resultDto;
ModelState.Clear();
return(View(empModel));
}
public ResultDto Update(EmployeeKYCDto employeeKyc)
{
return(InsertUpdateEmployeeKYC(employeeKyc));
}
