public ActionResult DeleteConfirmed(int id)
{
LossModel lossModel = db.LossModels.Find(id);
db.LossModels.Remove(lossModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,GoodId,WarhouseId,DateOpen,Count,Comments")] LossModel lossModel)
{
if (ModelState.IsValid)
{
db.Entry(lossModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GoodId = new SelectList(db.GoodModels, "Id", "Name", lossModel.GoodId);
ViewBag.WarhouseId = new SelectList(db.Warhousies, "Id", "Name", lossModel.WarhouseId);
return(View(lossModel));
}
// GET: Loss/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LossModel lossModel = db.LossModels.Find(id);
if (lossModel == null)
{
return(HttpNotFound());
}
return(View(lossModel));
}
// GET: Loss/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LossModel lossModel = db.LossModels.Find(id);
if (lossModel == null)
{
return(HttpNotFound());
}
ViewBag.GoodId = new SelectList(db.GoodModels, "Id", "Name", lossModel.GoodId);
ViewBag.WarhouseId = new SelectList(db.Warhousies, "Id", "Name", lossModel.WarhouseId);
return(View(lossModel));
}
public async static Task <List <LossModel> > Parse(string path)
{
Excel.Application xlApp = null;
Excel.Workbook xlWorkbook = null;
Excel._Worksheet xlWorksheet = null;
Excel.Range xlRange = null;
try
{
string separator = NumberFormatInfo.CurrentInfo.CurrencyDecimalSeparator;
var models = new List <LossModel>();
//Create COM Objects. Create a COM object for everything that is referenced
xlApp = new Excel.Application();
xlWorkbook = xlApp.Workbooks.Open(path);
xlWorksheet = xlWorkbook.Sheets[1];
xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;
int rowStart = 6;
//iterate over the rows and columns and print to the console as it appears in the file
//excel is not zero based!!
var res = await Task.Run(() =>
{
for (int i = rowStart; i <= rowCount; i++)
{
var model = new LossModel();
for (int j = 1; j <= colCount; j++)
{
//either collect data cell by cell or DO you job like insert to DB
if (xlRange.Cells[i, j] != null && xlRange.Cells[i, j].Value2 != null)
{
//data += xlRange.Cells[i, j].Value2.ToString();
if (j == 1)
{
model.Region = xlRange.Cells[i, j].Value2.ToString();
}
else if (j == 2)
{
string amount = xlRange.Cells[i, j].Value2.ToString().Replace(".", separator).Replace(",", separator);
model.Amount = decimal.Parse(amount);
//double _amount = double.Parse(amount);
//model.Amount = (decimal)_amount;
models.Add(model);
}
}
}
}
return(models);
});
return(res);
}
catch (Exception ex)
{
throw;
}
finally
{
if (xlWorkbook != null)
{
xlWorkbook.Close(false);
}
if (xlApp != null)
{
xlApp.Quit();
}
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlRange);
xlRange = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlWorksheet);
xlWorksheet = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlWorkbook);
xlWorkbook = null;
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
xlApp = null;
GC.Collect();
//GC.WaitForPendingFinalizers();
}
}
