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