public ActionResult CreateCustomer(ERPAPD_Customer cus, HttpPostedFileBase file) { if (asset.Create) { ERPAPD_Customer item = new ERPAPD_Customer(); try { using (IDbConnection dbConn = ERPAPD.Helpers.OrmliteConnection.openConn()) { item.CustomerID = getLastIdCustomer(); item.ShortName = cus.ShortName; item.CustomerName = cus.CustomerName; item.TaxCode = cus.TaxCode; item.UnitId = cus.UnitId; item.Website = cus.Website; item.Source = cus.Source; item.CompanyType = cus.CompanyType; item.Category = cus.Category; item.CustomerType = cus.CustomerType; //BaoHV item.AgencyType = cus.AgencyType; item.AgencyRule = cus.AgencyRule; //End item.Area = cus.Area; item.Country = cus.Country; item.Province = cus.Province; item.District = cus.District; item.Wards = cus.Wards; item.Address = cus.Address; item.Phone = cus.Phone; item.Address2 = cus.Address2; item.Phone2 = cus.Phone2; item.Fax = cus.Fax; item.Account = cus.Account; //item.BankCode = cus.BankCode; item.BankName = cus.BankName; item.BankBranch = cus.BankBranch; item.Sponsor = cus.Sponsor; item.Position = cus.Position; item.StaffId = cus.StaffId; item.Status = "MOI"; item.RowCreatedUser = currentUser.UserName; item.RowCreatedAt = DateTime.Now; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); Helpers.UploadFile.CreateFolder(Server.MapPath("~/Images/" + item.CustomerID + "/")); var path = Path.Combine(Server.MapPath("~/Images/" + item.CustomerID + "/"), fileName); file.SaveAs(path); item.FileName = fileName; } dbConn.Insert <ERPAPD_Customer>(item); } } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } //return RedirectToAction("Index", "MnDetailEmployer", new { CustomerID = item.CustomerID }); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền." })); } }
public ActionResult ImportFromExcel() { try { using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn()) { if (Request.Files["FileUpload"] != null && Request.Files["FileUpload"].ContentLength > 0) { string fileExtension = System.IO.Path.GetExtension(Request.Files["FileUpload"].FileName); if (fileExtension == ".xlsx") { string fileLocation = string.Format("{0}/{1}", Server.MapPath("~/Excel"), "[" + currentUser.UserName + "-" + DateTime.Now.ToString("yyyyMMddHHmmss") + "]" + Request.Files["FileUpload"].FileName); string errorFileLocation = string.Format("{0}/{1}", Server.MapPath("~/Excel"), "[" + currentUser.UserName + "-" + DateTime.Now.ToString("yyyyMMddHHmmss") + "-Error]" + Request.Files["FileUpload"].FileName); if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } Request.Files["FileUpload"].SaveAs(fileLocation); var rownumber = 2; var total = 0; FileInfo fileInfo = new FileInfo(fileLocation); var excelPkg = new ExcelPackage(fileInfo); FileInfo template = new FileInfo(Server.MapPath(@"~\ExportExcelFile\TW_Goods_Category.xlsx")); template.CopyTo(errorFileLocation); FileInfo _fileInfo = new FileInfo(errorFileLocation); var _excelPkg = new ExcelPackage(_fileInfo); ExcelWorksheet oSheet = excelPkg.Workbook.Worksheets["TW_Goods_Category"]; ExcelWorksheet eSheet = _excelPkg.Workbook.Worksheets["TW_Goods_Category"]; //remove row int totalRows = oSheet.Dimension.End.Row; for (int i = 2; i <= totalRows; i++) { string CatID = oSheet.Cells[i, 1].Value != null ? oSheet.Cells[i, 1].Value.ToString() : "0"; try { var write = new ERPAPD_Customer(); var checkCatNumber = dbConn.FirstOrDefault <ERPAPD_Customer>("CatId={0}", CatID); if (checkCatNumber != null) { //write.Note = Note; dbConn.Update(write); total++; } else { //write.Note = Note; dbConn.Insert(write); total++; } } catch (Exception e) { //eSheet.Cells[rownumber, 2].Value = CatName; //eSheet.Cells[rownumber, 3].Value = Status; //eSheet.Cells[rownumber, 5].Value = CatNumber; eSheet.Cells[rownumber, 10].Value = e.Message; rownumber++; continue; } } _excelPkg.Save(); return(Json(new { success = true, total = total, totalError = rownumber - 2, link = errorFileLocation })); } else { return(Json(new { success = false, error = "File extension is not valid. *.xlsx please." })); } } else { return(Json(new { success = false, error = "File upload null" })); } } } catch (Exception ex) { return(Json(new { success = false, error = ex.Message })); } }
public ActionResult Customer_Update(ERPAPD_Customer request) { using (IDbConnection dbConn = ERPAPD.Helpers.OrmliteConnection.openConn()) { try { if (!string.IsNullOrEmpty(request.CustomerID)) { var customer = dbConn.FirstOrDefault <ERPAPD_Customer>("CustomerID={0}", request.CustomerID); if (!string.IsNullOrEmpty(request.ShortName)) { customer.ShortName = request.ShortName.Trim(); } if (!string.IsNullOrEmpty(request.CustomerName)) { customer.CustomerName = request.CustomerName.Trim(); } if (!string.IsNullOrEmpty(request.TaxCode)) { customer.TaxCode = request.TaxCode.Trim(); } if (!string.IsNullOrEmpty(request.Source)) { customer.Source = request.Source.Trim(); } if (!string.IsNullOrEmpty(request.CompanyType)) { customer.CompanyType = request.CompanyType.Trim(); } if (!string.IsNullOrEmpty(request.Category)) { customer.Category = request.Category.Trim(); } if (!string.IsNullOrEmpty(request.CustomerType)) { customer.CustomerType = request.CustomerType.Trim(); } if (!string.IsNullOrEmpty(request.Area)) { customer.Area = request.Area.Trim(); } if (!string.IsNullOrEmpty(request.Country)) { customer.Country = request.Country.Trim(); } if (!string.IsNullOrEmpty(request.District)) { customer.District = request.District.Trim(); } if (!string.IsNullOrEmpty(request.Province)) { customer.Province = request.Province.Trim(); } if (!string.IsNullOrEmpty(request.Wards)) { customer.Wards = request.Wards.Trim(); } if (!string.IsNullOrEmpty(request.Address)) { customer.Address = request.Address.Trim(); } if (!string.IsNullOrEmpty(request.Address2)) { customer.Address2 = request.Address2.Trim(); } if (!string.IsNullOrEmpty(request.Phone)) { customer.Phone = request.Phone.Trim(); } if (!string.IsNullOrEmpty(request.Phone2)) { customer.Phone2 = request.Phone2.Trim(); } if (!string.IsNullOrEmpty(request.StaffId.ToString())) { customer.StaffId = int.Parse(request.StaffId.ToString()); } if (!string.IsNullOrEmpty(request.Fax)) { customer.Fax = request.Fax.Trim(); } if (!string.IsNullOrEmpty(request.BankCode)) { customer.BankCode = request.BankCode.Trim(); } if (!string.IsNullOrEmpty(request.BankBranch)) { customer.BankBranch = request.BankBranch.Trim(); } if (!string.IsNullOrEmpty(request.BankName)) { customer.BankName = request.BankName.Trim(); } if (!string.IsNullOrEmpty(request.Sponsor)) { customer.Sponsor = request.Sponsor.Trim(); } if (!string.IsNullOrEmpty(request.Position)) { customer.Position = request.Position.Trim(); } if (!string.IsNullOrEmpty(request.Website)) { //Array arr = request.Website.Trim().Split(','); customer.Website = request.Website; } //BaoHV add customer.AgencyType = !string.IsNullOrEmpty(request.AgencyType)? request.AgencyType: customer.AgencyType; customer.AgencyRule = request.AgencyRule; customer.RowUpdatedAt = DateTime.Now; customer.RowUpdatedUser = currentUser.UserName; dbConn.Update(customer); return(Json(new { success = true })); } else { ModelState.AddModelError("error", ""); return(Json(new { success = false })); } } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } } }