public AlertMessage ImportCollection(ImportCollectionModel model)
{
AlertMessage alert = new AlertMessage();
//if (!IsAccessible(ModuleCode.ImportCollection))
//{
// alert.Text = StaticMessage.ERR_ACCESS_DENIED;
// return alert;
//}
int month = 0;
int year = 0;
try
{
string[] arr = model.FormattedValidDate.Split('-');
month = Convert.ToInt16(arr[0]);
year = Convert.ToInt16(arr[1]);
List <UploadCollectionModel> list = GetDataCollection(model.InputFile, year, month);
if (list != null)
{
if (list.Count != 0)
{
IRepository <OpenBalanceMonthly> repoOpenBalanceMonthly = _unitOfWork.GetRepository <OpenBalanceMonthly>();
//_unitOfWork.BeginTransaction();
StringBuilder sb = new StringBuilder();
foreach (var item in list)
{
sb.Append($"INSERT INTO OpenBalanceMonthly VALUES ({item.TAHUN},{item.BULAN},{item.PLANT},'{item.REFERENCE}',{item.CUSTOMER},'{item.DUEDATE.ToString("yyyy-MM-dd")}','{item.CG1}','{item.PH3}','{item.MATERIAL}',{item.AMOUNT_09},'{item.INTERV}') \n");
//OpenBalanceMonthly openBalanceMonthly = new OpenBalanceMonthly()
//{
// AMOUNT_09 = item.AMOUNT_09,
// INTERV = item.INTERV,
// TAHUN = item.TAHUN,
// BULAN = item.BULAN,
// CG1 = item.CG1,
// CUSTOMER = item.CUSTOMER,
// REFERENCE = item.REFERENCE,
// PLANT = item.PLANT,
// PH3 = item.PH3,
// MATERIAL = item.MATERIAL,
// DUEDATE = item.DUEDATE
//};
//repoOpenBalanceMonthly.Insert(openBalanceMonthly);
}
//_logger.Write("SQL", DateTime.Now, sb.ToString());
//_unitOfWork.Commit();
}
}
}
catch (Exception ex)
{
alert.Text = StaticMessage.ERR_INVALID_INPUT;
return(alert);
}
return(alert);
}
public ActionResult Import(ImportCollectionModel model)
{
AlertMessage alert = new AlertMessage();
CollectionBusiness business = new CollectionBusiness();
alert = business.ImportCollection(model);
return(RedirectToAction("Index"));
}
