//public static IEnumerable<PayrollIntrestGainDTO> GetAllTPayrollInterestGainDTO(IEnumerable<PayrollIntrestGain> Record) //{ // Mapper.CreateMap<PayrollIntrestGain, PayrollIntrestGainDTO>().ConvertUsing(m => // { // return new PayrollIntrestGainDTO // { // Id = m.Id, // EmpCode = m.EmpCode, // CustomerId = m.CustomerId, // EmployeeName = m.Employee.EmpName, // FyId = m.FyId, // MonthIndex = m.MonthIndex // }; // }); // return Mapper.Map<IEnumerable<PayrollIntrestGain>, IEnumerable<PayrollIntrestGainDTO>>(Record); //} public static PayrollIntrestGainDTO PayrollInterestDbToDTO(PayrollIntrestGain ModelData) { PayrollIntrestGainDTO Record = new PayrollIntrestGainDTO { Id = ModelData.Id, EmpCode = ModelData.EmpCode, CustomerId = ModelData.CustomerId, EmployeeName = ModelData.Employee.EmpName, FyId = ModelData.FyId, MonthIndex = ModelData.MonthIndex //IsuranceClaimId = ModelData.IsuranceClaimId, //InsuranceCompanyId = ModelData.InsuranceCompanyId, //InsuredAmount = ModelData.InsuredAmount, //PremiumAmount = ModelData.PremiumAmount, //AmountType = ModelData.AmountType, //StartDate = ModelData.StartDate, //EndDate = ModelData.EndDate, //InsuranceClaimFyId = ModelData.InsuranceClaimFyId, //EmpCode = ModelData.EmpCode, //InsurancePolicyNumber = ModelData.InsurancePolicyNumber, //Employee = new EmployeeDTO //{ // EmpCode = ModelData.Employee.EmpCode, // EmpName = ModelData.Employee.EmpName, //}, //InsuranceCompany = new InsuranceCompanyDTO //{ // Id = ModelData.InsuranceCompany.Id, // CompanyName = ModelData.InsuranceCompany.CompanyName //} }; return(Record); }
public ActionResult Import() { PayrollIntrestGainDTO Record = new PayrollIntrestGainDTO(); DropDownListViewmodelcs ddlvm = DropDownlist(); Record.OfficeList = ddlvm.OfficeList; return(View(Record)); }
public static PayrollIntrestGain ConvertRespondentInfoFromDTO(PayrollIntrestGainDTO PayrollAllowanceMasterDTO) { Mapper.CreateMap <PayrollIntrestGainDTO, PayrollIntrestGain>().ConvertUsing( m => { return(new PayrollIntrestGain { Id = m.Id, CustomerId = m.CustomerId, EmpCode = m.EmpCode, FyId = m.FyId, InterestGain = m.InterestGain, MonthIndex = m.MonthIndex //AllowanceMasterId = m.AllowanceMasterId, //PercentageAmount = m.PercentageAmount, //Value = m.Value }); }); return(Mapper.Map <PayrollIntrestGainDTO, PayrollIntrestGain>(PayrollAllowanceMasterDTO)); }
public static IEnumerable <PayrollIntrestGainDTO> PayrollInterestDbListToDTOList(IEnumerable <PayrollIntrestGain> ModelData) { List <PayrollIntrestGainDTO> ReturnRecord = new List <PayrollIntrestGainDTO>(); foreach (PayrollIntrestGain Row in ModelData) { PayrollIntrestGainDTO Record = new PayrollIntrestGainDTO { Id = Row.Id, EmpCode = Row.EmpCode, CustomerId = Row.CustomerId, EmployeeName = Row.Employee.EmpName, InterestGain = Row.InterestGain, FyId = Row.FyId, MonthIndex = Row.MonthIndex //IsuranceClaimId = Row.IsuranceClaimId, //InsuranceCompanyId = Row.InsuranceCompanyId, //InsuredAmount = Row.InsuredAmount, //PremiumAmount = Row.PremiumAmount, //AmountType = Row.AmountType, //StartDate = Row.StartDate, //EndDate = Row.EndDate, //InsuranceClaimFyId = Row.InsuranceClaimFyId, //EmpCode = Row.EmpCode, //InsurancePolicyNumber = Row.InsurancePolicyNumber, //Employee = new EmployeeDTO //{ // EmpCode = Row.Employee.EmpCode, // EmpName = Row.Employee.EmpName, //}, //InsuranceCompany = new InsuranceCompanyDTO //{ // Id = Row.InsuranceCompany.Id, // CompanyName = Row.InsuranceCompany.CompanyName //} }; ReturnRecord.Add(Record); } return(ReturnRecord); }
public ActionResult Import(PayrollIntrestGainDTO Record, HttpPostedFileBase file) { //Record.AllowanceMasterList = _PayrollAllowanceMasterService.GetAllowanceMasterList(); DropDownListViewmodelcs ddlvm = DropDownlist(); Record.OfficeList = ddlvm.OfficeList; try { string result; result = file.FileName; DataSet ds = new DataSet(); DataTable dts = new DataTable(); string fileExtension = System.IO.Path.GetExtension(result); if (fileExtension == ".xls" || fileExtension == ".xlsx") { string fileLocation = Server.MapPath("~/Content/InterestGainImport/") + result; if (!Directory.Exists(Server.MapPath("~/Content/InterestGainImport/"))) { Directory.CreateDirectory(Server.MapPath("~/Content/InterestGainImport/")); } if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } file.SaveAs(Path.Combine(Server.MapPath("~/Content/InterestGainImport/"), result)); string excelConnectionString = string.Empty; excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; //connection String for xls file format. if (fileExtension == ".xls") { excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } //connection String for xlsx file format. else if (fileExtension == ".xlsx") { excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; } //Create Connection to Excel work book and add oledb namespace OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); excelConnection.Open(); DataTable dt = new DataTable(); dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dt == null) { TempData["Danger"] = "Corrupt file. Please check the file and try again"; return(RedirectToAction("Index")); } String[] excelSheets = new String[dt.Rows.Count]; int t = 0; //excel data saves in temp file here. foreach (DataRow row in dt.Rows) { excelSheets[t] = row["TABLE_NAME"].ToString(); t++; } OleDbConnection excelConnection1 = new OleDbConnection(excelConnectionString); string query = string.Format("Select * from [{0}]", excelSheets[0]); using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, excelConnection1)) { dataAdapter.Fill(ds); dataAdapter.Fill(dts); } excelConnection.Close(); } List <PayrollIntrestGainDTO> modelrecord = new List <PayrollIntrestGainDTO>(); foreach (DataRow d in dts.Rows) { PayrollIntrestGainDTO single = new PayrollIntrestGainDTO() { CustomerId = d["CustomerId"].ToString(), //AllowanceMasterId = Record.AllowanceMasterId, //EmpCode = Convert.ToInt32(d["EmployeeCode"].ToString()), InterestGain = Convert.ToDecimal(d["Value"].ToString()), //PercentageAmount = d["PercentageAmount"].ToString(), //Value = Convert.ToDecimal(d["Value"].ToString()), }; single.EmpCode = _unitOfWork.EmployeeRepository.Get(x => x.CustomerId == single.CustomerId).FirstOrDefault().EmpCode; single.EmployeeName = _empService.GetEmployeeByID((int)single.EmpCode).Name; modelrecord.Add(single); PayrollIntrestGain domainrecord = PayrollInterestGainResponseFormatter.ConvertRespondentInfoFromDTO(single); PayrollIntrestGain pastrecord = _unitOfWork.InterestGainRepository.Get(x => x.EmpCode == single.EmpCode).FirstOrDefault(); if (pastrecord != null) { _unitOfWork.InterestGainRepository.Delete(pastrecord); } _unitOfWork.InterestGainRepository.Create(domainrecord); } ViewBag.AllowanceImportedList = modelrecord; TempData["Success"] = "Allowance Data imported successfully"; } catch (IOException ex) { TempData["Danger"] = ex.Message; } catch (Exception ex) { TempData["Danger"] = ex.Message; } return(View(Record)); }