private TargetSalesViewModel GetTargetSalesViewModel(SalesTarget item, List <RHHeader> rhHeaders)
{
TargetSalesViewModel model = new TargetSalesViewModel()
{
RayonCode = item.RayonCode,
AchiGroup = item.AchiGroup,
Material = item.Material,
Division = item.Division,
Target = item.Target.Value.ToString("N0"),
SLM_NIK = item.SLM.Value,
SLM_Name = rhHeaders.FirstOrDefault(x => x.RayonCode.Equals(item.RayonCode)).SLMObj1.FullName,
FSS_NIK = item.FSS.Value,
FSS_Name = rhHeaders.FirstOrDefault(x => x.RayonCode.Equals(item.RayonCode)).FSSObj1.FullName,
Bulan = item.Bulan.Value,
Tahun = item.Tahun.Value
};
return(model);
}
private List <TargetSalesViewModel> GetListTargetSalesViewModel(HttpPostedFileBase postedFile)
{
IWorkbook workbook = GetWorkbook(postedFile);
if (workbook == null)
{
return(null);
}
ISheet sheet = workbook.GetSheetAt(0);
List <TargetSalesViewModel> result = new List <TargetSalesViewModel>();
TargetSalesViewModel model = null;
object obj = null;
int tempInt = 0;
List <string> listRemarks = null;
for (int i = 1; i <= sheet.LastRowNum; i++)
{
tempInt = 0;
listRemarks = new List <string>();
try
{
IRow row = sheet.GetRow(i);
if (row == null)
{
continue;
}
model = new TargetSalesViewModel();
obj = GetObjFromCell(row.GetCell(0));
model.FSS_NIK = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
obj = GetObjFromCell(row.GetCell(1));
model.FSS_Name = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(2));
model.SLM_NIK = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
obj = GetObjFromCell(row.GetCell(3));
model.SLM_Name = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(4));
model.RayonCode = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(5));
model.AchiGroup = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(6));
model.Division = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(7));
model.Material = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(8));
model.Bulan = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
obj = GetObjFromCell(row.GetCell(9));
model.Tahun = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
obj = GetObjFromCell(row.GetCell(10));
model.Target = obj == null ? "0" : double.Parse(obj.ToString().Trim()).ToString("N0");
}
catch (Exception ex)
{
//model.Remarks = StaticMessage.ERR_INVALID_ROW_XLS;
}
finally
{
if (!string.IsNullOrEmpty(model.RayonCode))
{
result.Add(model);
}
}
}
return(result);
}
