//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));
}
