public ActionResult EditSale(ViewModels.SalesEdit form) { var currUser = Database.Session.Query <Models.User>() .Where(u => u.Username == HttpContext.User.Identity.Name) .FirstOrDefault(); Models.Sales saleToEdit = Database.Session.Query <Models.Sales>() .Where(c => c.sales_id == form.sale_id) .FirstOrDefault(); if (form.quantity <= 0) { ModelState.AddModelError("quantity", "Satış Adedi 0 veya 0'dan Küçük Olamaz."); } if (!ModelState.IsValid) { return(View(form)); } var stockForSale = Database.Session.Query <Stock>() .Where(s => s.StockId == saleToEdit.stock_id.StockId) .FirstOrDefault(); int beforeQuantity = saleToEdit.quantity; int afterQuantity = form.quantity; if (afterQuantity - beforeQuantity >= 0) { saleToEdit.quantity += Math.Abs(afterQuantity - beforeQuantity); saleToEdit.sale_sum += Math.Abs(afterQuantity - beforeQuantity) * stockForSale.Unitprice; currUser.Balance += Math.Abs(afterQuantity - beforeQuantity) * stockForSale.Unitprice; stockForSale.Quantityinstock -= Math.Abs(afterQuantity - beforeQuantity); } else { saleToEdit.quantity -= Math.Abs(afterQuantity - beforeQuantity); saleToEdit.sale_sum -= Math.Abs(afterQuantity - beforeQuantity) * stockForSale.Unitprice; currUser.Balance -= Math.Abs(afterQuantity - beforeQuantity) * stockForSale.Unitprice; stockForSale.Quantityinstock += Math.Abs(afterQuantity - beforeQuantity); } try { Database.Session.Update(saleToEdit); Database.Session.Update(currUser); Database.Session.Update(stockForSale); } catch (Exception ex) { ModelState.AddModelError(String.Empty, ex.Message); return(View(form)); } Database.Session.Flush(); return(RedirectToAction("Index", new { id = currUser.Id })); }
public ActionResult EditSale(int id) { Models.Sales saleToEdit = Database.Session.Query <Models.Sales>() .Where(c => c.sales_id == id) .FirstOrDefault(); return(View(new ViewModels.SalesEdit { sale_id = id, quantity = saleToEdit.quantity, user_id = saleToEdit.belongsToUser.Id })); }
public HttpResponseMessage Put(int Id, Models.Sales value) { try { var Sales = from d in db.TrnSales where d.Id == Id select d; if (Sales.Any()) { var UpdatedSale = Sales.FirstOrDefault(); DateTime salesDate = Convert.ToDateTime(value.SalesDate, new CultureInfo("en-US")); DateTime renewalDate = Convert.ToDateTime(value.RenewalDate, new CultureInfo("en-US")); DateTime expiryDate = Convert.ToDateTime(value.ExpiryDate, new CultureInfo("en-US")); SqlDateTime SalesDate = new SqlDateTime(new DateTime(Convert.ToDateTime(salesDate).Year, + Convert.ToDateTime(salesDate).Month, + Convert.ToDateTime(salesDate).Day)); SqlDateTime RenewalDate = new SqlDateTime(new DateTime(Convert.ToDateTime(renewalDate).Year, + Convert.ToDateTime(renewalDate).Month, + Convert.ToDateTime(renewalDate).Day)); SqlDateTime ExpiryDate = new SqlDateTime(new DateTime(Convert.ToDateTime(expiryDate).Year, + Convert.ToDateTime(expiryDate).Month, + Convert.ToDateTime(expiryDate).Day)); UpdatedSale.ProductPackageId = value.ProductPackageId; UpdatedSale.UserId = value.UserId; UpdatedSale.SalesNumber = value.SalesNumber; UpdatedSale.SalesDate = SalesDate.Value; UpdatedSale.RenewalDate = RenewalDate.Value; UpdatedSale.ExpiryDate = ExpiryDate.Value; UpdatedSale.Particulars = value.Particulars; UpdatedSale.Quantity = value.Quantity; UpdatedSale.Price = value.Price; UpdatedSale.Amount = value.Amount; UpdatedSale.IsActive = value.IsActive; UpdatedSale.IsRefunded = value.IsRefunded; db.SubmitChanges(); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } return(Request.CreateResponse(HttpStatusCode.OK)); } catch (NullReferenceException) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public ActionResult SalesCreatePost([Bind(Include = "SalesId,CustomerID,ProductID,Amount")] Models.Sales productEntry) { if (db.Sales.ToArray().Count() == 0) { productEntry.SalesId = 0; } else { productEntry.SalesId = db.Sales.ToArray().LastOrDefault().SalesId + 1; } db.Sales.Add(productEntry); db.SaveChanges(); return(RedirectToAction("Index")); }
public int Post(Models.Sales value) { try { Data.TrnSale NewSale = new Data.TrnSale(); SqlDateTime SalesDate = new SqlDateTime(new DateTime(Convert.ToDateTime(value.SalesDate).Year, + Convert.ToDateTime(value.SalesDate).Month, + Convert.ToDateTime(value.SalesDate).Day)); SqlDateTime RenewalDate = new SqlDateTime(new DateTime(Convert.ToDateTime(value.RenewalDate).Year, + Convert.ToDateTime(value.RenewalDate).Month, + Convert.ToDateTime(value.RenewalDate).Day)); SqlDateTime ExpiryDate = new SqlDateTime(new DateTime(Convert.ToDateTime(value.ExpiryDate).Year, + Convert.ToDateTime(value.ExpiryDate).Month, + Convert.ToDateTime(value.ExpiryDate).Day)); NewSale.ProductPackageId = value.ProductPackageId; NewSale.UserId = value.UserId; NewSale.SalesNumber = value.SalesNumber; NewSale.SalesDate = SalesDate.Value; NewSale.RenewalDate = RenewalDate.Value; NewSale.ExpiryDate = ExpiryDate.Value; NewSale.Particulars = value.Particulars; NewSale.Quantity = value.Quantity; NewSale.Price = value.Price; NewSale.Amount = value.Amount; NewSale.IsActive = value.IsActive; NewSale.IsRefunded = value.IsRefunded; db.TrnSales.InsertOnSubmit(NewSale); db.SubmitChanges(); return(NewSale.Id); } catch { return(0); } }