private HierTagihViewModel GetHierTagihViewModel(DataRow dr)
{
HierTagihViewModel model = new HierTagihViewModel();
model.RayonCode = dr.IsNull("RayonCode") ? null : dr["RayonCode"].ToString();
model.PlantCode = dr.IsNull("Plant") ? null : dr["Plant"].ToString();
model.NSMNik = dr.IsNull("NSMNIK") ? 0 : Convert.ToInt32(dr["NSMNIK"]);
model.NSMFullname = dr.IsNull("NSMFullName") ? null : dr["NSMFullName"].ToString();
model.ASMNik = dr.IsNull("ASMNIK") ? 0 : Convert.ToInt32(dr["ASMNIK"]);
model.ASMFullname = dr.IsNull("ASMFullName") ? null : dr["ASMFullName"].ToString();
model.FSSNik = dr.IsNull("FSSNIK") ? 0 : Convert.ToInt32(dr["FSSNIK"]);
model.FSSFullname = dr.IsNull("FSSFullName") ? null : dr["FSSFullName"].ToString();
model.SLMNik = dr.IsNull("SLMNIK") ? 0 : Convert.ToInt32(dr["SLMNIK"]);
model.SLMFullname = dr.IsNull("SLMFullName") ? null : dr["SLMFullName"].ToString();
model.CollectorNik = dr.IsNull("CollectorNIK") ? 0 : Convert.ToInt32(dr["CollectorNIK"]);
model.CollectorFullname = dr.IsNull("CollectorFullName") ? null : dr["CollectorFullName"].ToString();
model.FakturisNik = dr.IsNull("FakturisNIK") ? 0 : Convert.ToInt32(dr["FakturisNIK"]);
model.FakturisFullname = dr.IsNull("FakturisFullName") ? null : dr["FakturisFullName"].ToString();
model.SPVFakturisNik = dr.IsNull("SPVFakturisNIK") ? 0 : Convert.ToInt32(dr["SPVFakturisNIK"]);
model.SPVFakturisFullname = dr.IsNull("SPVFakturisFullName") ? null : dr["SPVFakturisFullName"].ToString();
model.ValidFromDate = dr.IsNull("ValidFrom") ? DateTime.MinValue : Convert.ToDateTime(dr["ValidFrom"]);
model.FormattedValidFrom = model.ValidFromDate.ToString(AppConstant.DefaultFormatDate);
model.ValidToDate = dr.IsNull("ValidTo") ? DateTime.MinValue : Convert.ToDateTime(dr["ValidTo"]);
model.FormattedValidTo = model.ValidToDate.ToString(AppConstant.DefaultFormatDate);
return(model);
}
private HierTagihViewModel GetHierTagihViewModel(RTHeader item)
{
HierTagihViewModel model = new HierTagihViewModel()
{
Id = item.ID,
RayonCode = item.RayonCode,
PlantCode = item.Plant,
NSMNik = item.NSM ?? 0,
ASMNik = item.ASM ?? 0,
FSSNik = item.FSS ?? 0,
SLMNik = item.SLM ?? 0,
CollectorNik = item.Collector,
FakturisNik = item.Fakturis,
SPVFakturisNik = item.SPVFakturis,
ValidFromDate = item.ValidFrom,
ValidToDate = item.ValidTo
};
model.FormattedValidFrom = item.ValidFrom.ToString(_formattedDate);
model.FormattedValidTo = item.ValidTo.ToString(_formattedDate);
model.NSMFullname = item.NSMObj == null ? null : item.NSMObj.FullName;
model.ASMFullname = item.ASMObj == null ? null : item.ASMObj.FullName;
model.FSSFullname = item.FSSObj == null ? null : item.FSSObj.FullName;
model.SLMFullname = item.SLMObj == null ? null : item.SLMObj.FullName;
//model.CollectorFullname = item.CollectorObj == null ? null : item.CollectorObj.FULLNAME;
//model.FakturisFullname = item.FakturisObj == null ? null : item.FakturisObj.FULLNAME ;
//model.SPVFakturisFullname = item.SPVFakturisObj == null ? null : item.SPVFakturisObj.FULLNAME;
return(model);
}
private List <HierTagihViewModel> GetListHierTagihViewModel(HttpPostedFileBase postedFile)
{
IWorkbook workbook = GetWorkbook(postedFile);
if (workbook == null)
{
return(null);
}
ISheet sheet = workbook.GetSheetAt(0);
List <HierTagihViewModel> result = new List <HierTagihViewModel>();
HierTagihViewModel model = null;
object obj = null;
int tempInt = 0;
for (int i = 1; i <= sheet.LastRowNum; i++)
{
IRow row = sheet.GetRow(i);
if (row == null)
{
continue;
}
tempInt = 0;
model = new HierTagihViewModel();
obj = GetObjFromCell(row.GetCell(0));
model.RayonCode = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(1));
model.PlantCode = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(2));
//model.NSMNik = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
if (obj != null && int.TryParse(obj.ToString().Trim(), out tempInt))
{
model.NSMNik = tempInt;
}
else
{
model.NSMNik = 0;
}
obj = GetObjFromCell(row.GetCell(3));
model.NSMFullname = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(4));
//model.ASMNik = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
if (obj != null && int.TryParse(obj.ToString().Trim(), out tempInt))
{
model.ASMNik = tempInt;
}
else
{
model.ASMNik = 0;
}
obj = GetObjFromCell(row.GetCell(5));
model.ASMFullname = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(6));
//model.FSSNik = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
if (obj != null && int.TryParse(obj.ToString().Trim(), out tempInt))
{
model.FSSNik = tempInt;
}
else
{
model.FSSNik = 0;
}
obj = GetObjFromCell(row.GetCell(7));
model.FSSFullname = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(8));
//model.SLMNik = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
if (obj != null && int.TryParse(obj.ToString().Trim(), out tempInt))
{
model.SLMNik = tempInt;
}
else
{
model.SLMNik = 0;
}
obj = GetObjFromCell(row.GetCell(9));
model.SLMFullname = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(10));
//model.CollectorNik = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
if (obj != null && int.TryParse(obj.ToString().Trim(), out tempInt))
{
model.CollectorNik = tempInt;
}
else
{
model.CollectorNik = 0;
}
obj = GetObjFromCell(row.GetCell(11));
model.CollectorFullname = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(12));
//model.FakturisNik = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
if (obj != null && int.TryParse(obj.ToString().Trim(), out tempInt))
{
model.FakturisNik = tempInt;
}
else
{
model.FakturisNik = 0;
}
obj = GetObjFromCell(row.GetCell(13));
model.FakturisFullname = obj == null ? null : obj.ToString().Trim();
obj = GetObjFromCell(row.GetCell(14));
//model.SPVFakturisNik = obj == null ? 0 : Convert.ToInt32(obj.ToString().Trim());
if (obj != null && int.TryParse(obj.ToString().Trim(), out tempInt))
{
model.SPVFakturisNik = tempInt;
}
else
{
model.SPVFakturisNik = 0;
}
obj = GetObjFromCell(row.GetCell(15));
model.SPVFakturisFullname = obj == null ? null : obj.ToString().Trim();
if (!string.IsNullOrEmpty(model.RayonCode))
{
result.Add(model);
}
}
return(result);
}
