public static Response NewPurchase(NewPurchaseView view, string userName)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var user = db.Users.Where(u => u.UserName == userName).FirstOrDefault();
var purchase = new Purchase
{
CompanyId = user.CompanyId,
ProviderId = view.ProviderId,
Date = view.Date,
Remarks = view.Remarks,
StateId = DBHelper.GetState("Criado", db),
WareHouseId = view.ProviderId
};
db.Purchase.Add(purchase);
db.SaveChanges();
var details = db.PurchaseDetailTmps.Where(odt => odt.UserName == userName).ToList();
foreach (var detail in details)
{
var purchaseDetail = new PurchaseDetails
{
Description = detail.Description,
PurchaseId = purchase.PurchaseId,
Price = detail.Price,
ProductId = detail.ProductId,
Quantity = detail.Quantity,
TaxRate = detail.TaxRate
};
db.PurchaseDetails.Add(purchaseDetail);
db.PurchaseDetailTmps.Remove(detail);
}
db.SaveChanges();
transaction.Commit();
return(new Response {
Succeeded = true
});
}
catch (Exception ex)
{
transaction.Rollback();
return(new Response
{
Message = ex.Message,
Succeeded = false
});
throw;
}
}
}
public ActionResult Create(NewPurchaseView view)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var purchase = new Purchase
{
Date = view.Date,
SupplierId = view.SupplierId,
CellarId = view.CellarId
};
db.Purchases.Add(purchase);
db.SaveChanges();
var details = db.PurchaseDetailBkps.Where(pdb => pdb.User == User.Identity.Name).ToList();
foreach (var detail in details)
{
var purchaseDetail = new PurchaseDetail
{
PurchaseId = purchase.PurchaseId,
ProductId = detail.ProductId,
Description = detail.Description,
Cost = detail.Cost,
Quantity = detail.Quantity,
ManufacturingLot = detail.ManufacturingLot,
DueDate = detail.DueDate
};
db.PurchaseDetails.Add(purchaseDetail);
db.PurchaseDetailBkps.Remove(detail);
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
ModelState.AddModelError(string.Empty, ex.Message);
}
}
return(RedirectToAction("Index"));
}
ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description", view.CellarId);
ViewBag.SupplierId = new SelectList(db.Suppliers, "SupplierId", "Tradename", view.SupplierId);
view.Details = db.PurchaseDetailBkps.Where(pdb => pdb.User == User.Identity.Name).ToList();
return(View(view));
}
// GET: Purchases/Create
public ActionResult Create()
{
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
ViewBag.SupplierId = new SelectList(CombosHelper.GetSuppliers(user.CompanyId), "SupplierId", "FullName");
ViewBag.WarehouseId = new SelectList(CombosHelper.GetWarehouses(user.CompanyId), "WarehouseId", "Name");
var view = new NewPurchaseView {
Date = DateTime.Now,
Details = db.PurchaseDetailTmps.Where(pdt => pdt.UserName == User.Identity.Name).ToList(),
};
return(View(view));
}
// GET: Purchases/Create
public ActionResult Create()
{
ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description");
ViewBag.SupplierId = new SelectList(db.Suppliers, "SupplierId", "Tradename");
var view = new NewPurchaseView
{
Date = DateTime.Now,
Details = db.PurchaseDetailBkps.Where(pdb => pdb.User == User.Identity.Name).ToList()
};
return(View(view));
}
private void OpenNewPurchase()
{
if (DesignerProperties.GetIsInDesignMode(new System.Windows.DependencyObject()))
{
return;
}
try
{
NewPurchaseView P = new NewPurchaseView();
UI.Enviroment.LoadNewTab(P, "New Purchase");
}
catch (Exception E)
{
ExepionLogger.Logger.LogException(E);
ExepionLogger.Logger.Show(E);
}
}
public ActionResult Create(NewPurchaseView view)
{
if (ModelState.IsValid)
{
var response = MovementsHelper.NewPurchase(view, User.Identity.Name);
if (response.Succeeded)
{
return(RedirectToAction("Index"));
}
ModelState.AddModelError(string.Empty, response.Message);
}
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
ViewBag.SupplierId = new SelectList(CombosHelper.GetSuppliers(user.CompanyId), "SupplierId", "FullName");
ViewBag.WarehouseId = new SelectList(CombosHelper.GetWarehouses(user.CompanyId), "WarehouseId", "Name");
view.Details = db.PurchaseDetailTmps.Where(pdt => pdt.UserName == User.Identity.Name).ToList();
return(View(view));
}
public static Response NewPurchase(NewPurchaseView view, string userName)
{
using (var transaccion = db.Database.BeginTransaction())
{
try
{
var user = db.Users.Where(u => u.UserName == userName).FirstOrDefault();
var purchase = new Purchase
{
CompanyId = user.CompanyId,
SupplierId = view.SupplierId,
Date = view.Date,
Remarks = view.Remarks,
StateId = DBHelper.GetState("Created", db),
WarehouseId = view.WarehouseId,
};
db.Purchases.Add(purchase);
db.SaveChanges();
var details = db.PurchaseDetailTmps.Where(pdt => pdt.UserName == userName).ToList();
foreach (var detail in details)
{
var purchaseDetail = new PurchaseDetail
{
Description = detail.Description,
PurchaseId = purchase.PurchaseId,
Price = detail.Price,
ProductId = detail.ProductId,
Quantity = detail.Quantity,
TaxRate = detail.TaxRate,
};
db.PurchaseDetails.Add(purchaseDetail);
db.PurchaseDetailTmps.Remove(detail);
var inventory = db.Inventories.Where(i => i.WarehouseId == view.WarehouseId && i.ProductId == detail.ProductId).FirstOrDefault();
if (inventory == null)
{
inventory = new Inventory
{
WarehouseId = view.WarehouseId,
ProductId = detail.ProductId,
Stock = detail.Quantity,
};
db.Inventories.Add(inventory);
}
else
{
inventory.Stock += inventory.Stock + detail.Quantity;
db.Entry(inventory).State = EntityState.Modified;
}
//db.SaveChanges();
}
db.SaveChanges();
transaccion.Commit();
return(new Response {
Succeeded = true
});
}
catch (Exception ex)
{
transaccion.Rollback();
if (ex.InnerException != null && ex.InnerException.InnerException != null)
{
return(new Response {
Succeeded = false, Message = ex.InnerException.InnerException.Message
});
}
else if (ex.InnerException != null)
{
return(new Response {
Succeeded = false, Message = ex.InnerException.Message
});
}
else
{
return(new Response {
Succeeded = false, Message = ex.Message
});
}
}
}
}
private void OpenWindow(string windowName)
{
try
{
WindowName name = windowName.ConvertToWindowName();
Window window = null;
switch (name)
{
case WindowName.NewSaleView:
window = new NewSaleView();
break;
case WindowName.CustomerView:
window = new CustomerView();
break;
case WindowName.NewPurchaseView:
window = new NewPurchaseView();
break;
case WindowName.SupplierView:
window = new SupplierView();
break;
case WindowName.SaleView:
window = new SaleView();
break;
case WindowName.PurchaseView:
window = new PurchaseView();
break;
case WindowName.ProductView:
window = new ProductView();
break;
case WindowName.ServiceView:
window = new ServiceView();
break;
case WindowName.ChargeView:
window = new ChargeView();
break;
case WindowName.SaleReportView:
window = new SaleReportView();
break;
case WindowName.PurchaseReportView:
window = new PurchaseReportView();
break;
case WindowName.ProductReportView:
window = new ProductReportView();
break;
}
window?.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
