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