public void LoadFormObjects() { DateLabel.Text = DateTime.Now.Date.ToShortDateString(); currentSaleObject = new SaleClass(); currentSaleObject.SaleItems = new List <SaleItemClass>(); OrderIDField.Text = generateID(); }
public void refreshSalesItems() { currentSaleObject = new SaleClass(); currentSaleObject.SaleItems = new List <SaleItemClass>(); SaleItemsList.DataSource = null; SaleItemsList.Refresh(); clearFields(); }
public void PostSale(SaleClass sale) { if (sale.Id == 0) { long newId = Sales.Select(@class => @class.Id).Max() + 1; sale.Id = newId; Sales.Add(sale); } else { Sales = Sales.Where(@class => @class.Id != sale.Id).ToList(); Sales.Add(sale); } Utils.SaveToFile(); }
private void BuyBtm_MouseDown(object sender, MouseButtonEventArgs e) { int i; ChangeInfo[] changeInfo = new ChangeInfo[Court.Length]; for (i = 0; i < Court.Length; i++) { changeInfo[i] = new ChangeInfo(); changeInfo[i].Id = Court[i].GetProductId(); changeInfo[i].Amount = Court[i].GetAmount(); } SaleClass.SaleWork(changeInfo, ManagerId, SectionId); CourtViewer.Children.Clear(); Court = new PositionBlank[0]; StorageViewer.Children.Clear(); Storage = new PositionBlank[0]; ReadStorage(); }
public void PostSale(SaleClass sale) { dataAccess.PostSale(sale); }
public void PostSale(SaleClass sale) { throw new NotImplementedException(); }
public void PostSale(SaleClass sale) { throw new NotImplementedException(); }
public void PostSale(SaleClass sale) { dataAccess.PostSale(sale); }
public void PostSale(SaleClass sale) { if (sale.Id == 0) { long newId = Sales.Select(@class => @class.Id).Max() + 1; sale.Id = newId; Sales.Add(sale); } else { Sales = Sales.Where(@class => @class.Id != sale.Id).ToList(); Sales.Add(sale); } Utils.SaveToFile(); }
public void RecordSale(int checkoutOrHold, string modeOfPayment) { decimal discount = 0; decimal taxapplied = 0; if (AmountPaidField.Text.Length > 0) { try { var amountpaid = Decimal.Parse(AmountPaidField.Text); var total = Decimal.Parse(TotalSaleField.Text); BalanceField.Text = decimal.Round(amountpaid - total, 2).ToString(); if (total <= amountpaid) { decimal balance = amountpaid - total; //start creating db records using (var db = new POSApplication.Model.posdbEntities()) { if (TotalDiscountField.Text.Length > 0) { try { discount = Decimal.Parse(TotalDiscountField.Text); } catch (Exception e1) { MessageBox.Show(@"Enter numeric value for Discount"); } } if (TaxAppliedField.Text.Length > 0) { try { taxapplied = Decimal.Parse(TaxAppliedField.Text); } catch (Exception e1) { MessageBox.Show(@"Enter numeric value for Tax"); } } total = total + (total * (taxapplied / 100)); total = total - (total * (discount / 100)); BalanceField.Text = balance.ToString(); var so = new purchasesorder { AmountPaid = amountpaid }; currentSaleObject.AmountPaid = amountpaid; so.Balance = balance; currentSaleObject.Balance = decimal.Round((decimal)balance, 2); so.Discount = discount; currentSaleObject.Discount = discount; so.ModeOfPayment = modeOfPayment; so.PurchaseAmount = Decimal.Parse(TotalSaleField.Text); currentSaleObject.SaleAmount = decimal.Round((decimal)so.PurchaseAmount, 2); //so.SaleDate = DateTime.Now.Date; so.PurchaseDate = dateTimePicker1.Value.Date; //so.Date_dateofmonth_int = DateTime.Now.Day; so.Date_dateofmonth_int = dateTimePicker1.Value.Day; if (DateTime.Now.DayOfWeek == DayOfWeek.Sunday) { so.Date_Dayofweek_int = 7; } if (DateTime.Now.DayOfWeek == DayOfWeek.Monday) { so.Date_Dayofweek_int = 1; } if (DateTime.Now.DayOfWeek == DayOfWeek.Tuesday) { so.Date_Dayofweek_int = 2; } if (DateTime.Now.DayOfWeek == DayOfWeek.Wednesday) { so.Date_Dayofweek_int = 3; } if (DateTime.Now.DayOfWeek == DayOfWeek.Thursday) { so.Date_Dayofweek_int = 4; } if (DateTime.Now.DayOfWeek == DayOfWeek.Friday) { so.Date_Dayofweek_int = 5; } if (DateTime.Now.DayOfWeek == DayOfWeek.Saturday) { so.Date_Dayofweek_int = 6; } //so.Date_DayofWeek_string = DateTime.Now.DayOfWeek.ToString(); so.Date_DayofWeek_string = dateTimePicker1.Value.DayOfWeek.ToString(); //so.date_month_int = DateTime.Now.Month; so.date_month_int = dateTimePicker1.Value.Month; if (DateTime.Now.Month == 1) { so.date_month_string = "January"; } if (DateTime.Now.Month == 2) { so.date_month_string = "February"; } if (DateTime.Now.Month == 3) { so.date_month_string = "March"; } if (DateTime.Now.Month == 4) { so.date_month_string = "April"; } if (DateTime.Now.Month == 5) { so.date_month_string = "May"; } if (DateTime.Now.Month == 6) { so.date_month_string = "June"; } if (DateTime.Now.Month == 7) { so.date_month_string = "July"; } if (DateTime.Now.Month == 8) { so.date_month_string = "August"; } if (DateTime.Now.Month == 9) { so.date_month_string = "September"; } if (DateTime.Now.Month == 10) { so.date_month_string = "October"; } if (DateTime.Now.Month == 11) { so.date_month_string = "November"; } if (DateTime.Now.Month == 12) { so.date_month_string = "December"; } so.date_year_int = dateTimePicker1.Value.Year; so.time_hour = int.Parse(dateTimePicker1.Value.Hour.ToString()); so.PurchaseTime = dateTimePicker1.Value.TimeOfDay; so.UserName = AppConfig.loggedInUserName; //setting the status to checkout or hold sale. so.PurchaseStatus = checkoutOrHold; so.TaxPercentage = taxapplied; currentSaleObject.TaxPercentage = taxapplied; so.TerminalID = AppConfig.TerminalID; //recording the purchase as purchase on hold if (checkoutOrHold == 1) { so.HoldInvoice = 1; } else { so.HoldInvoice = 0; } so.InvoiceID = OrderIDField.Text; db.purchasesorders.Add(so); db.SaveChanges(); //Adding purchase Items int orderid = so.OrderID; foreach (var item in currentSaleObject.SaleItems) { decimal tax = item.TaxPercentage / 100; decimal purchaseprice = (item.PriceApplied * tax) + item.PriceApplied; decimal itemdiscount = item.Discount / 100; purchaseprice = (purchaseprice * itemdiscount) + purchaseprice; var s = new purchasesorderdetail { ProductID = item.ProductID, InvoiceID = OrderIDField.Text, Discount = item.Discount, PurchasePrice = item.PriceApplied, Quantity = item.Quantity }; s.PurchasePrice = purchaseprice; s.TaxPercentage = item.TaxPercentage; db.purchasesorderdetails.Add(s); db.SaveChanges(); ////////////////////////////////////////////////////////////////////////////////// //closing previous inventory record. ////////////////////////////////////////////////////////////////////////////////// Model.inventory c = (from x in db.inventories where (x.ProductID == item.ProductID && x.UpdateDt == null && x.PurchasePrice == purchaseprice || (x.ProductID == item.ProductID && x.UpdateDt == null && x.PurchasePrice == 0 && x.SalePrice == 0)) select x).SingleOrDefault(); if (c != null) { c.UpdateDt = dateTimePicker1.Value; db.SaveChanges(); decimal existingQuantity; if (c.SumQuantity != null) { existingQuantity = (decimal)c.SumQuantity; } else { existingQuantity = 0; } var inv = new inventory { ProductID = item.ProductID, CreateDt = dateTimePicker1.Value, PurchaseDate = dateTimePicker1.Value, PurchasePrice = purchaseprice, Quantity = item.Quantity, //TaxPaid = item.TaxPercentage, //ReorderValue = c.ReorderValue, UpdateDt = null, PackingTypeID = null, SumQuantity = existingQuantity + item.Quantity, SalePrice = c.SalePrice, InvoiceID = so.InvoiceID }; db.inventories.Add(inv); db.SaveChanges(); } else { decimal existingQuantity = 0; var d = (from x in db.inventories where x.ProductID == item.ProductID && x.UpdateDt == null select x).FirstOrDefault(); var inv = new inventory { ProductID = item.ProductID, CreateDt = dateTimePicker1.Value, PurchaseDate = dateTimePicker1.Value, PurchasePrice = purchaseprice, Quantity = item.Quantity, UpdateDt = null, PackingTypeID = null, SumQuantity = existingQuantity + item.Quantity, SalePrice = 0, InvoiceID = so.InvoiceID }; db.inventories.Add(inv); db.SaveChanges(); } } ///////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////// if (checkoutOrHold == 1) { MessageBox.Show(@"Purchase is put on HOLD. You can open the Purchases on hold again from Invoices Form."); } else { PrintPage(); currentSaleObject = new SaleClass(); currentSaleObject.SaleItems = new List <SaleItemClass>(); SaleItemsList.DataSource = null; SaleItemsList.Refresh(); clearFields(); } } } else { MessageBox.Show(@"Amount Paid Value should be larger or equal to Total"); } } catch (Exception e1) { MessageBox.Show(@"Enter numeric value for Amount Paid"); } } else { MessageBox.Show(@"Enter value for Amount Paid"); } }