public ActionResult Save(WarehouseInfo info) { var result = info.Save(ModelState, UserID, Employee.ID, Employee.BussinessID); var isAjaxRequest = Request.IsAjaxRequest(); string view; object model; if (result) { view = isAjaxRequest ? Views.ListPartial : Views.List; model = WarehouseInfo.Find(UserID, Employee.ID, Employee.BussinessID, "Luu thông tin thành công"); } else { view = isAjaxRequest ? Views.SavePartial : Views.Save; model = info; } if (isAjaxRequest) { return(Json(new { result = result, html = RenderPartialViewToString(view, model), }, JsonRequestBehavior.DenyGet)); } else { return(View(view, model)); } }
private void UpdateTemplate(string fileName) { var warehouses = WarehouseInfo.Find(UserID, Employee.ID, Employee.BussinessID); if (warehouses.Data.Count > 0) { HSSFWorkbook hssfwb; using (FileStream file = new FileStream(fileName, FileMode.Open, FileAccess.Read)) { hssfwb = new HSSFWorkbook(file); } var sheet = hssfwb.GetSheetAt(0); var rowCount = sheet.LastRowNum; for (var i = 0; i < warehouses.Data.Count; i++) { if (i + 1 > rowCount) { sheet.CreateRow(i + 1); } var row = sheet.GetRow(i + 1); if (row.Cells.FirstOrDefault(c => c.ColumnIndex == 10) == null) { row.CreateCell(10); } row.Cells.FirstOrDefault(c => c.ColumnIndex == 10).SetCellValue(warehouses.Data[i].Name); } using (var fs = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write)) { hssfwb.Write(fs); } } }
public ActionResult List() { var data = WarehouseInfo.Find(UserID, Employee.ID, Employee.BussinessID); if (Request.IsAjaxRequest()) { return(Json(new { html = RenderPartialViewToString(Views.ListPartial, data) }, JsonRequestBehavior.AllowGet)); } return(View(Views.List, data)); }
public ActionResult Remove(int id) { WarehouseInfo.Remove(UserID, Employee.ID, id); var model = WarehouseInfo.Find(UserID, Employee.ID, Employee.BussinessID, "Xóa thông tin thành công"); if (Request.IsAjaxRequest()) { return(Json(new { html = RenderPartialViewToString(Views.ListPartial, model) }, JsonRequestBehavior.AllowGet)); } return(View(Views.List, model)); }
public static List <ImexItem> Read(int userID, int employeeID, FileInfo fileInfo, int bussinessID) { var result = new List <ImexItem>(); HSSFWorkbook hssfwb; using (FileStream file = new FileStream(fileInfo.FullName, FileMode.Open, FileAccess.Read)) { hssfwb = new HSSFWorkbook(file); } var sheet = hssfwb.GetSheetAt(0); if (sheet.LastRowNum > 0) { var whs = new List <string>(); for (var i = 1; i <= sheet.LastRowNum; i++) { var row = sheet.GetRow(i); try { var wh = row.GetCellValue <string>(2); if (!String.IsNullOrEmpty(wh) && !whs.Contains(wh)) { whs.Add(wh); } var item = new ImexItem(); item.Code = row.GetCellValue <string>(0); //item.WarehouseID = warehouseID; item.WarehouseName = wh; item.Price = row.GetCellValue <decimal>(3); item.Quantity = row.GetCellValue <int>(4); result.Add(item); } catch { } } var warehouses = WarehouseInfo.Find(userID, employeeID, whs); foreach (var item in result) { if (warehouses.FirstOrDefault(i => i.Name == item.WarehouseName) != null) { item.WarehouseID = warehouses.FirstOrDefault(i => i.Name == item.WarehouseName).ID; } } if (result.Count > 0) { var dbItems = ImexItem.Get(userID, employeeID, result); foreach (var dbItem in dbItems) { foreach (var item in result.Where(i => i.Code == dbItem.Code)) { item.ID = dbItem.ID; item.Code = dbItem.Code; item.Name = dbItem.Name; item.Price = dbItem.Price; //item.Quantity = 1; } } } result = result.Where(i => i.ID > 0 && i.WarehouseID > 0).ToList(); } return(result); }