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