public ActionResult DeleteConfirmed(int id)
{
EntryStock stock = db.EntryStock.Find(id);
using (var trans = db.Database.BeginTransaction())
{
int idUser = (int)Session["idUser"]; //who is login
try
{
stock.DeactivateStock();
db.SaveChanges();
Log log = new Log
{
Who = idUser,
EntryStockId = id,
ProductId = stock.ProductId,
CompanyId = stock.CompanyId,
New = "DISABLED",
Old = "ACTIVATED"
};
db.Log.Add(log);
db.SaveChanges();
trans.Commit();
TempData["confirm"] = "SUCCESSFUL DELETE";
}
catch
{
trans.Rollback();
ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER";
}
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(RedirectToAction("Error500", "Error"));
}
try
{
int idUser = Session["idUser"] != null ? (int)Session["idUser"] : 0;
int permission = Session["permission"] != null ? (int)Session["permission"] : 0;
int idCompany = Session["permission"] != null ? (int)Session["idCompany"] : 0;
string userName = Session["permission"] != null ? (string)Session["username"] : null;
if (Check.IsLogOn(idUser, permission, idCompany, userName))
{
EntryStock stock = db.EntryStock.Find(id);
if (stock == null)
{
return(RedirectToAction("Error404", "Error"));
}
if (stock.Status != (StatusStockSaleProduct)1)
{
TempData["error"] = "YOU DO NOT HAVE PERMISSION";
return(RedirectToAction("Index"));
}
if (Check.IsSuperAdmin(permission))
{
ViewBag.CompanyId = new SelectList(db.Company, "IdCompany", "NameCompany", stock.CompanyId);
ViewBag.ProductId = new SelectList(db.Product, "IdProduct", "NameProduct", stock.ProductId);
}
else if (Check.IsStockist(permission) && idCompany == stock.CompanyId)
{
Company company = db.Company.Where(c => c.IdCompany == idCompany).FirstOrDefault();
List <Company> companies = new List <Company>();
companies.Add(company);
ViewBag.CompanyId = new SelectList(companies, "IdCompany", "NameCompany", stock.CompanyId);
ViewBag.ProductId = new SelectList(db.Product.Where(p => p.CompanyId == idCompany), "IdProduct", "NameProduct", stock.ProductId);
}
else
{
TempData["error"] = "YOU DO NOT HAVE PERMISSION";
return(RedirectToAction("Index"));
}
return(View(stock));
}
else
{
TempData["error"] = "YOU ARE NOT LOGGED IN";
return(RedirectToAction("LogIn", "Employees"));
}
}
catch
{
return(RedirectToAction("Error500", "Error"));
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(RedirectToAction("Error500", "Error"));
}
try
{
int idUser = (int)Session["idUser"];
int permission = (int)Session["permission"];
int idCompany = (int)Session["idCompany"];
string userName = (string)Session["username"];
if (Check.IsLogOn(idUser, permission, idCompany, userName))
{
EntryStock entryStock = db.EntryStock.Find(id);
if (entryStock == null)
{
return(RedirectToAction("Error404", "Error"));
}
if (entryStock.Status != (StatusStockSaleProduct)1)
{
TempData["error"] = "YOU DO NOT HAVE PERMISSION";
return(RedirectToAction("Index"));
}
else if (Check.IsSuperAdmin(permission) || (Check.IsStockist(permission) && idCompany == entryStock.CompanyId))
{
return(View(entryStock));
}
else
{
TempData["error"] = "YOU DO NOT HAVE PERMISSION";
return(RedirectToAction("Index"));
}
}
else
{
TempData["error"] = "YOU ARE NOT LOGGED IN";
return(RedirectToAction("LogIn", "Employees"));
}
}
catch
{
return(RedirectToAction("Error500", "Error"));
}
}
private void ShowStock(object sender, EventArgs e)
{
EntryStock.Focus();
}
public ActionResult Edit([Bind(Include = "IdStock, FabicationDate, ExpirationDate, ProductBatch, Amount, ProductId, CompanyId")] EntryStock stock)
{
if (ModelState.IsValid)
{
EntryStock oldStock = db.EntryStock.Find(stock.IdStock);
if (oldStock == null)
{
ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER";
return(RedirectToAction("Index"));
}
else if (!oldStock.Equals(stock))
{
using (var trans = db.Database.BeginTransaction())
{
int idUser = (int)Session["idUser"]; //who is login
try
{
Log log = new Log
{
//[U] in DB refers to an Update
New = "[C]" + stock.FabicationDate.ToString("dd/MM/yyyy") + " " + stock.ExpirationDate.ToString("dd/MM/yyyy") + " " + stock.ProductBatch
+ " " + stock.Amount,
Old = oldStock.FabicationDate.ToString("dd/MM/yyyy") + " " + oldStock.ExpirationDate.ToString("dd/MM/yyyy") + " " + oldStock.ProductBatch
+ " " + oldStock.Amount,
Who = idUser,
EntryStockId = oldStock.IdStock,
CompanyId = oldStock.CompanyId,
ProductId = stock.ProductId
};
oldStock.FabicationDate = stock.FabicationDate;
oldStock.ExpirationDate = stock.ExpirationDate;
oldStock.ProductBatch = stock.ProductBatch;
oldStock.Amount = stock.Amount;
//Can exchange the product
oldStock.ProductId = stock.ProductId;
db.SaveChanges();
db.Log.Add(log);
db.SaveChanges();
trans.Commit();
TempData["confirm"] = "SUCCESSFUL CHANGES";
}
catch
{
trans.Rollback();
ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER";
goto ReturnIfError;
}
}
}
else
{
TempData["message"] = "NO CHANGES WERE RECORDED";
}
return(RedirectToAction("Index"));
}
ReturnIfError:
int permission = Session["permission"] != null ? (int)Session["permission"] : 0;
int idCompany = Session["idCompany"] != null ? (int)Session["idCompany"] : 0;
if (permission > 0)
{
if (Check.IsSuperAdmin(permission))
{
ViewBag.CompanyId = new SelectList(db.Company, "IdCompany", "NameCompany", stock.CompanyId);
ViewBag.ProductId = new SelectList(db.Product, "IdProduct", "NameProduct", stock.ProductId);
}
else if (Check.IsSupervisor(permission))
{
Company company = db.Company.Where(c => c.IdCompany == idCompany).FirstOrDefault();
List <Company> companies = new List <Company>();
companies.Add(company);
ViewBag.CompanyId = new SelectList(companies, "IdCompany", "NameCompany", idCompany);
ViewBag.ProductId = new SelectList(db.Product.Where(p => p.CompanyId == idCompany), "IdProduct", "NameProduct", stock.ProductId);
}
return(View(stock));
}
else
{
TempData["error"] = "YOU ARE NOT LOGGED IN";
return(RedirectToAction("LogIn", "Employees"));
}
}
public ActionResult Create([Bind(Include = "FabicationDate,ExpirationDate,ProductBatch,Amount,ProductId,CompanyId")] EntryStock entryStock)
{
if (ModelState.IsValid)
{
EntryStock entryStockDB = db.EntryStock.Where(p => p.CompanyId == entryStock.CompanyId && p.ProductId == p.ProductId &&
p.ProductBatch.Equals(entryStock.ProductBatch) && p.FabicationDate.Equals(entryStock.FabicationDate) &&
p.ExpirationDate.Equals(entryStock.ExpirationDate)).FirstOrDefault();
if (entryStockDB == null)
{
using (var trans = db.Database.BeginTransaction())
{
try
{
int idUser = (int)Session["idUser"]; //who is login
db.EntryStock.Add(entryStock);
db.SaveChanges();
#region Register Log
Log log = new Log
{
//[C] in DB refers to an Create
New = "[C]" + entryStock.FabicationDate.ToString("dd/MM/yyyy") + " " + entryStock.ExpirationDate.ToString("dd/MM/yyyy") + " " + entryStock.ProductBatch
+ " " + entryStock.Amount,
Who = idUser,
EntryStockId = entryStock.IdStock,
CompanyId = entryStock.CompanyId,
ProductId = entryStock.ProductId
};
db.Log.Add(log);
db.SaveChanges();
#endregion
trans.Commit();
TempData["confirm"] = "NEW STOCK INSERTED";
}
catch
{
trans.Rollback();
ViewBag.error = "ERROR 500, TRAY AGAIN, IF THE ERROR PERSIST CONTACT THE SYSTEM SUPPLIER";
goto ReturnIfError;
}
}
}
else
{
ViewBag.error = "THIS STOCK ALREADY INSERTED, TRY EDIT IT";
}
return(RedirectToAction("Index"));
}
ReturnIfError:
int permission = Session["permission"] != null ? (int)Session["permission"] : 0;
int idCompany = Session["idCompany"] != null ? (int)Session["idCompany"] : 0;
if (permission > 0)
{
if (Check.IsSuperAdmin(permission))
{
ViewBag.CompanyId = new SelectList(db.Company, "IdCompany", "NameCompany", entryStock.CompanyId);
ViewBag.ProductId = new SelectList(db.Product, "IdProduct", "NameProduct", entryStock.ProductId);
}
else if (Check.IsSupervisor(permission))
{
Company company = db.Company.Where(c => c.IdCompany == idCompany).FirstOrDefault();
List <Company> companies = new List <Company>();
companies.Add(company);
ViewBag.CompanyId = new SelectList(companies, "IdCompany", "NameCompany", idCompany);
ViewBag.ProductId = new SelectList(db.Product.Where(p => p.CompanyId == idCompany), "IdProduct", "NameProduct", entryStock.ProductId);
}
return(View(entryStock));
}
else
{
TempData["error"] = "YOU ARE NOT LOGGED IN";
return(RedirectToAction("LogIn", "Employees"));
}
}
