private void MarkOrderButton_Click(object sender, EventArgs e) { var SelectedRow = dataGridView1.CurrentRow; if (SelectedRow == null) { MessageBox.Show("No data selected"); return; } var joinedOrderId = SelectedRow.Cells["Order_Id"].Value.ToString(); var orderIds = StationIdHelper.SeperateStationId(joinedOrderId); int orderId = int.Parse(orderIds[1]); int stationOrderId = int.Parse(orderIds[0]); var order = db.Orders.Where(aa => aa.OrderId == orderId && aa.StationOrderId == stationOrderId).FirstOrDefault(); order.IsDelivered = true; order.StatusCode = (int)LocalDBStatusCode.Updated; try { db.SaveChanges(); MessageBox.Show("SuccessFully marked delivered"); } catch (Exception ee) { MessageBox.Show("Fail to mark order \n" + ee.Message); } OnLoad(); }
private void SaveButton_Click(object sender, EventArgs e) { if (ExtraNameField.Text == null || ExtraNameField.Text == "") { MessageBox.Show("Please enter Name"); return; } Item newExtra = new Item(); newExtra.ItemName = ExtraNameField.Text; newExtra.IsExtra = true; newExtra.StatusCode = (int)LocalDBStatusCode.Added; FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); db.Items.Add(newExtra); try { db.SaveChanges(); MessageBox.Show("Added Successfully"); this.Close(); } catch (Exception ee) { MessageBox.Show("Failed to save item \n" + ee.Message); } }
private void button4_Click(object sender, EventArgs e) { if (AccountNo.Text.Count() != 0 && dataGridView2.SelectedRows.Count != 0) { DataGridViewRow rowBank = dataGridView2.SelectedRows[0]; string bankId = (rowBank.Cells["ID"].Value.ToString()); List <string> seperate1 = Helpers.StationIdHelper.SeperateStationId(bankId); int SupplierbankId = int.Parse(seperate1[1]); int STATIONSupplierbankId = int.Parse(seperate1[0]); DataGridViewRow row = dataGridView1.SelectedRows[0]; string Supplierid = (row.Cells["SupplierID"].Value.ToString()); List <string> seperate2 = Helpers.StationIdHelper.SeperateStationId(Supplierid); int supplierID = int.Parse(seperate2[1]); int StationID = int.Parse(seperate2[0]); Entity.FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); var BANKiD = db.SupplierBankDetails.Where(aa => aa.SupplierBankId == SupplierbankId && aa.StationSupplierBankId == STATIONSupplierbankId).FirstOrDefault(); if (MessageBox.Show("Are you sure?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.SupplierBankDetails.Remove(BANKiD); db.SaveChanges(); MessageBox.Show("Account Deleted"); AccountNo.Text = string.Empty; GetAccounts(Supplierid); } else { AccountNo.Text = string.Empty; GetAccounts(Supplierid); } } else { MessageBox.Show("Select Account Number"); } }
private void button1_Click(object sender, EventArgs e) { FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); if (textBox1.Text.Count() != 0 && textBox2.Text.Count() != 0 && textBox3.Text.Count() != 0 && textBox3.Text.Count() < 15) { string userName = textBox1.Text; string password = textBox2.Text; string phone = textBox3.Text; string email = textBox4.Text; string designation = textBox5.Text; Entity.Login existingUser = db.Logins.Where(aa => aa.UserName.Equals(userName)).FirstOrDefault(); if (existingUser == null) { Entity.Login login = new Entity.Login(); login.UserName = userName; login.Password = password; login.Phone = phone; login.Email = email; login.Designation = designation; db.Logins.Add(login); db.SaveChanges(); MessageBox.Show("User Added"); this.Close(); } else { MessageBox.Show("UserName Already Exists"); } } else { MessageBox.Show("Fill Empty Fields"); } }
private void button2_Click(object sender, EventArgs e) { string paymentToBePaid = PaymentToBePaid.Text; if (paymentToBePaid.Count() > 0) { if (paymentToBePaid.All(char.IsDigit)) { FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); Entity.SupplierDuePayment payment = new SupplierDuePayment(); payment.Date = dateTimePicker2.Value; payment.SupplierId = _supplierID; payment.StationSupplierId = _supplierStationId; payment.AmountToBePaid = int.Parse(paymentToBePaid); db.SupplierDuePayments.Add(payment); db.SaveChanges(); MessageBox.Show("AmountToBePaid Added"); PaymentToBePaid.Text = string.Empty; RefreshAmountToPaid(); totalPaymentsMade(); totalPaymentsToBepaid(); TotalRemainingDue(); } else { MessageBox.Show("Numbers Only"); } } else { MessageBox.Show("Enter Value"); } }
public void UploadNewCustomers() { FaridiaIronStoreEntities dbLocal = new FaridiaIronStoreEntities(); FaridiaIronStoreServerEntities dbServer = new FaridiaIronStoreServerEntities(); var newCustomers = dbLocal.Customers.Where(aa => aa.StatusCode == (int)LocalDBStatusCode.Added).ToList(); var config = new MapperConfiguration(cfg => cfg.CreateMap <Entity.Customer, ServerEntity.CustomerServer>()); var mapper = config.CreateMapper(); var customerserver = mapper.Map <List <Entity.Customer>, List <ServerEntity.CustomerServer> >(newCustomers); customerserver.ForEach(aa => aa.StatusCode = (int)ServerDBStatusCode.Added_From_Shop); newCustomers.ForEach(aa => aa.StatusCode = (int)LocalDBStatusCode.Updated_On_Server); try { var localDBTransaction = dbLocal.Database.BeginTransaction(); var ServerDBTransaction = dbServer.Database.BeginTransaction(); dbServer.CustomerServers.AddRange(customerserver); dbServer.SaveChanges(); dbLocal.SaveChanges(); localDBTransaction.Commit(); ServerDBTransaction.Commit(); } catch { throw; } }
private void button1_Click(object sender, EventArgs e) { string madePayments = MadePayment.Text; if (madePayments.Count() > 0) { if (madePayments.All(char.IsDigit)) { FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); Entity.SupplierPaymentMade paymentMade = new SupplierPaymentMade(); paymentMade.Date = dateTimePicker1.Value; paymentMade.SupplierId = _supplierID; paymentMade.StationSupplierId = _supplierStationId; paymentMade.PaymentMade = int.Parse(madePayments); db.SupplierPaymentMades.Add(paymentMade); db.SaveChanges(); MessageBox.Show("Payment Made"); MadePayment.Text = string.Empty; RefreshPaymentMade(); totalPaymentsMade(); totalPaymentsToBepaid(); TotalRemainingDue(); } else { MessageBox.Show("Numbers Only"); } } else { MessageBox.Show("Enter Value"); } }
private void button6_Click(object sender, EventArgs e) { string accountNo = AccountNo.Text; if (accountNo.Count() > 0) { if (dataGridView1.SelectedRows.Count != 0) { DataGridViewRow row = dataGridView1.SelectedRows[0]; string id = row.Cells["SupplierID"].Value.ToString(); List <string> seperate = Helpers.StationIdHelper.SeperateStationId(id); int supplierID = int.Parse(seperate[1]); int StationID = int.Parse(seperate[0]); Entity.FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); Entity.SupplierBankDetail supplierb = new SupplierBankDetail(); supplierb.SupplierId = supplierID; supplierb.StationSupplierId = StationID; supplierb.StationSupplierBankId = (int)Station.StationId; supplierb.AccountNo = accountNo; db.SupplierBankDetails.Add(supplierb); db.SaveChanges(); MessageBox.Show("Account Added"); AccountNo.Text = string.Empty; GetAccounts(id); } } else { MessageBox.Show("Enter Account Number"); } }
private void button5_Click_1(object sender, EventArgs e) { if (AccountNo.Text.Count() != 0 && dataGridView2.SelectedRows.Count != 0) { DataGridViewRow rowBank = dataGridView2.SelectedRows[0]; string SupplierbankIdC = rowBank.Cells["ID"].Value.ToString(); List <string> seperate = Helpers.StationIdHelper.SeperateStationId(SupplierbankIdC); int SupplierbankId = int.Parse(seperate[1]); int STATIONSupplierbankId = int.Parse(seperate[0]); string accountNo = AccountNo.Text; if (accountNo.Count() > 0) { DataGridViewRow row = dataGridView1.SelectedRows[0]; string seperateid = row.Cells["SupplierID"].Value.ToString(); // List<string> seperatesupplierID = Helpers.StationIdHelper.SeperateStationId(seperateid); // int supplierID = int.Parse(seperatesupplierID[1]); //int StationID = int.Parse(seperatesupplierID[0]); Entity.FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); Entity.SupplierBankDetail supplierb = db.SupplierBankDetails.Where(aa => aa.SupplierBankId == SupplierbankId && aa.StationSupplierBankId == STATIONSupplierbankId).FirstOrDefault(); supplierb.AccountNo = accountNo; db.SaveChanges(); MessageBox.Show("Account Edited"); AccountNo.Text = string.Empty; GetAccounts(seperateid); } } else { MessageBox.Show("Select Account Number"); } }
private void button1_Click_1(object sender, EventArgs e) { string nameCompany = CompanyName.Text; string adress = Adress.Text; string phoneNo = Phone.Text; string city = City.Text; Entity.FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); Entity.Supplier supplierExist = db.Suppliers.Where(aa => aa.Name.Equals(nameCompany)).FirstOrDefault(); if (supplierExist == null) { if (phoneNo.Count() > 0 && phoneNo.Count() < 20) { Entity.Supplier supplier = new Entity.Supplier(); supplier.Name = nameCompany; supplier.Address = adress; supplier.Phone = phoneNo; supplier.City = city; supplier.StationSupplierId = (int)Station.StationId; db.Suppliers.Add(supplier); db.SaveChanges(); MessageBox.Show("Saved"); this.Close(); } else { MessageBox.Show("Enter Valid PhoneNo"); } } else { MessageBox.Show("Supplier Already Exists"); } }
// event for save button private void button1_Click_1(object sender, EventArgs e) { if (string.IsNullOrEmpty(NameField.Text) || string.IsNullOrEmpty(PhoneField.Text) || string.IsNullOrEmpty(CityField.Text) || string.IsNullOrEmpty(AddressField.Text)) { MessageBox.Show("Please fill mendatory fields."); } else { Customer cust = new Customer(); cust.Name = NameField.Text; cust.Phone = PhoneField.Text; cust.Address = AddressField.Text; cust.City = CityField.Text; cust.StationCustomerId = (int)Station.StationId; cust.StatusCode = (int)LocalDBStatusCode.Added; db.Customers.Add(cust); db.SaveChanges(); MessageBox.Show("User Added"); LoadCustomers(); var joinedCustomerId = StationIdHelper.StationIdJoined(cust.StationCustomerId, cust.CustomerId); if (orderForm != null) { orderForm.SetCustomer(joinedCustomerId); } this.Close(); } }
private void button1_Click(object sender, EventArgs e) { FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); int id = int.Parse(textBox6.Text); Entity.Login login = db.Logins.Find(id); db.Logins.Remove(login); db.SaveChanges(); MessageBox.Show("User Deleted"); this.Close(); }
private void Button_Click(object sender, EventArgs e) { string nameCompany = CompanyName.Text; string adress = Adress.Text; string phoneNo = Phone.Text; string city = City.Text; FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); Entity.Supplier supplier = db.Suppliers.Where(a => a.SupplierId == _id && a.StationSupplierId == _supplierStationID).FirstOrDefault(); //IronStore.EntityFramework.SupplierBankDetail supplierBank = new EntityFramework.SupplierBankDetail(); //List<IronStore.EntityFramework.SupplierBankDetail> bankList = new List<SupplierBankDetail>(); supplier.Name = nameCompany; supplier.Address = adress; supplier.Phone = phoneNo; supplier.City = city; db.SaveChanges(); MessageBox.Show("Updated"); this.Close(); }
public void DownloadNewCustomers() { FaridiaIronStoreEntities dbLocal = new FaridiaIronStoreEntities(); FaridiaIronStoreServerEntities dbServer = new FaridiaIronStoreServerEntities(); var newServerCustomers = dbServer.CustomerServers.Where(aa => aa.StatusCode == (int)ServerDBStatusCode.Added_From_Home).ToList(); if (newServerCustomers.Count == 0) { return; } var config = new MapperConfiguration(cfg => cfg.CreateMap <ServerEntity.CustomerServer, Entity.Customer>()); var mapper = config.CreateMapper(); var customerLocal = mapper.Map <List <ServerEntity.CustomerServer>, List <Entity.Customer> >(newServerCustomers); newServerCustomers.ForEach(aa => aa.StatusCode = (int)ServerDBStatusCode.Updated_On_Both_Sides); customerLocal.ForEach(aa => aa.StatusCode = (int)LocalDBStatusCode.Updated_From_Server); try { var localDBTransaction = dbLocal.Database.BeginTransaction(); var ServerDBTransaction = dbServer.Database.BeginTransaction(); dbLocal.Customers.SqlQuery("SET IDENTITY_INSERT [Customer] On"); dbLocal.Customers.AddRange(customerLocal); dbLocal.SaveChanges(); dbLocal.Customers.SqlQuery("SET IDENTITY_INSERT [Customer] Off"); dbServer.SaveChanges(); localDBTransaction.Commit(); ServerDBTransaction.Commit(); } catch { throw; } }
private void button1_Click(object sender, EventArgs e) { FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); string loginId = textBox6.Text; string userName = textBox1.Text; string password = textBox2.Text; string phone = textBox3.Text; string email = textBox4.Text; string designation = textBox5.Text; int id = int.Parse(loginId); Entity.Login login = db.Logins.Where(a => a.LoginId == id).First(); login.UserName = userName; login.Password = password; login.Phone = phone; login.Email = email; login.Designation = designation; db.SaveChanges(); MessageBox.Show("User Updated"); this.Close(); }
public void UploadSupplierPaymentMade() { FaridiaIronStoreEntities dbLocal = new FaridiaIronStoreEntities(); FaridiaIronStoreServerEntities dbServer = new FaridiaIronStoreServerEntities(); var newSupplierPaymentsMadeLocal = dbLocal.SupplierPaymentMades.Where(aa => aa.StatusCode == (int)LocalDBStatusCode.Added).ToList(); if (newSupplierPaymentsMadeLocal.Count == 0) { return; } var config = new MapperConfiguration(cfg => cfg.CreateMap <Entity.SupplierPaymentMade, ServerEntity.SupplierPaymentMadeServer>()); var mapper = config.CreateMapper(); var supplierPaymentsMadeServer = mapper.Map <List <Entity.SupplierPaymentMade>, List <ServerEntity.SupplierPaymentMadeServer> >(newSupplierPaymentsMadeLocal); newSupplierPaymentsMadeLocal.ForEach(aa => aa.StatusCode = (int)LocalDBStatusCode.Updated_On_Server); supplierPaymentsMadeServer.ForEach(aa => aa.StatusCode = (int)ServerDBStatusCode.Added_From_Shop); try { var localDBTransaction = dbLocal.Database.BeginTransaction(); var ServerDBTransaction = dbServer.Database.BeginTransaction(); dbServer.SupplierPaymentMadeServers.AddRange(supplierPaymentsMadeServer); dbServer.SaveChanges(); dbLocal.SaveChanges(); localDBTransaction.Commit(); ServerDBTransaction.Commit(); } catch { throw; } }
private void button2_Click(object sender, EventArgs e) { string presetMasterPassword = "******"; FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); string userName = UserName.Text; string newPassword = NewPassword.Text; string masterPassword = MasterPassword.Text; if (userName.Count() != 0 && newPassword.Count() != 0 && masterPassword.Count() != 0) { Entity.Login existingUser = db.Logins.Where(aa => aa.UserName.Equals(userName)).FirstOrDefault(); if (existingUser != null) { if (masterPassword.Equals(presetMasterPassword)) { existingUser.Password = newPassword; MessageBox.Show("Password Changes"); db.SaveChanges(); this.Hide(); Login login = new Login(); login.Show(); } else { MessageBox.Show("Enter Valid MasterPassword"); } } else { MessageBox.Show("Enter Valid UserName"); } } else { MessageBox.Show("Fill All Fields"); } }
private void SaveButton_Click(object sender, EventArgs e) { if (AmountPaidField.Value == 0) { MessageBox.Show("Please enter Amount Paid"); return; } else if (AmountPaidField.Value > DueAmountField.Value) { MessageBox.Show("Amount paid cannot be greater than due amount"); return; } OrderPaymentMade orderPayment = new OrderPaymentMade(); orderPayment.CustomerId = customer.CustomerId; orderPayment.Date = DateTime.Now; orderPayment.StationCustomerId = customer.StationCustomerId; orderPayment.StationOrderPaymentMadeId = (int)Station.StationId; orderPayment.PaymentMade = (int)AmountPaidField.Value; orderPayment.StatusCode = (int)LocalDBStatusCode.Added; db.OrderPaymentMades.Add(orderPayment); try { db.SaveChanges(); MessageBox.Show("Payment added successfully"); this.Close(); } catch (Exception ee) { MessageBox.Show("Unexpected error occured \n" + ee.Message); } }
private void SaveButton_Click(object sender, EventArgs e) { if (NameField.Text == null || NameField.Text == "") { MessageBox.Show("please enter name"); return; } if (SotarField.Text == null || SotarField.Text == "") { DialogResult dialogResult = MessageBox.Show(" Sotar is not entered \n Do you want to save? ", " ", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { } else if (dialogResult == DialogResult.No) { return; } } if (ThicknessField.Text == null || ThicknessField.Text == "") { DialogResult dialogResult = MessageBox.Show(" Thickness is not entered \n Do you want to save? ", " ", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { } else if (dialogResult == DialogResult.No) { return; } } if (CityField.Text == null || CityField.Text == "") { MessageBox.Show("Please enter city"); return; } Item newItem = new Item(); newItem.City = CityField.Text; newItem.IsExtra = false; newItem.ItemName = NameField.Text; newItem.Sotar = SotarField.Text; newItem.thickness = ThicknessField.Text; newItem.StatusCode = (int)LocalDBStatusCode.Added; FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); db.Items.Add(newItem); try { db.SaveChanges(); MessageBox.Show("Item Added Successfully"); this.Close(); } catch (Exception ee) { MessageBox.Show("Failed to save item \n" + ee.Message); } }
private void SaveButton_Click(object sender, EventArgs e) { if (dataGridView1.Rows.Count == 0) { MessageBox.Show("Please enter orders"); return; } #region order Order order = new Order(); List <OrderLine> orderLinesList = new List <OrderLine>(); order.OrderLines = orderLinesList; var customerIds = StationIdHelper.SeperateStationId(CustomerComboBox.SelectedValue.ToString()); int customerId = int.Parse(customerIds[1]); int stationCustomerId = int.Parse(customerIds[0]); order.CustomerId = customerId; order.StationCustomerId = stationCustomerId; order.IsAdvanceOrder = AdvanceOrderCheck.Checked; order.Address = AddressTextBox.Text; order.Description = DescriptionTextBox.Text; order.IsDelivered = true; order.OrderDate = DateTime.Now; order.StationOrderId = (int)Station.StationId; order.StatusCode = (int)LocalDBStatusCode.Added; if (order.IsAdvanceOrder) { order.IsAdvanceOrder = true; order.DeliveryDate = DeliveryDateField.Value; order.IsDelivered = false; } #endregion #region payment if (PaymentMadeField.Value != 0) { if (PaymentMadeField.Value - TotalField.Value > 1) { MessageBox.Show("Amount Paid cannot be greater than Total Value"); return; } OrderPaymentMade orderPayment = new OrderPaymentMade(); orderPayment.CustomerId = (int)order.CustomerId; orderPayment.StationCustomerId = order.StationCustomerId; orderPayment.Date = DateTime.Now; orderPayment.PaymentMade = (int)PaymentMadeField.Value; orderPayment.StationOrderPaymentMadeId = (int)Station.StationId; orderPayment.StatusCode = (int)LocalDBStatusCode.Added; order.OrderPaymentMades.Add(orderPayment); } #endregion var rows = dataGridView1.Rows; if (rows.Count == 0) { MessageBox.Show("please enter some values"); return; } for (int i = 0; i < rows.Count; i++) { var row = rows[i]; #region Extras if (row.Cells["PricePerUnitColumn"].Value == null) { OrderLine orderLine = new OrderLine(); orderLine.ItemId = int.Parse(row.Cells["ItemIdColumn"].Value.ToString()); orderLine.PricePerUnit = double.Parse(row.Cells["TotalPriceColumn"].Value.ToString()); orderLine.WeightInKg = 1; orderLine.StationOrderLineId = (int)Station.StationId; orderLine.StatusCode = (int)LocalDBStatusCode.Added; //orderLine.isReturned=false orderLinesList.Add(orderLine); } #endregion #region Items else { OrderLine orderLine = new OrderLine(); orderLine.Bundle = int.Parse(row.Cells["BundleColumn"].Value.ToString()); if (orderLine.Bundle == 0) { orderLine.Bundle = null; } orderLine.ItemId = int.Parse(row.Cells["ItemIdColumn"].Value.ToString()); orderLine.Lengths = double.Parse(row.Cells["LengthColumn"].Value.ToString()); if (orderLine.Lengths == 0) { orderLine.Lengths = null; } orderLine.PieceCut = int.Parse(row.Cells["PieceCutColumn"].Value.ToString()); orderLine.PricePerUnit = double.Parse(row.Cells["PricePerUnitColumn"].Value.ToString()); //orderLine.isReturned=false var kg = double.Parse(row.Cells["KiloColumn"].Value.ToString()); var grams = double.Parse(row.Cells["GramColumn"].Value.ToString()); double totalWeightInKg; if (grams == 0) { totalWeightInKg = kg; } else { totalWeightInKg = kg + (grams / 1000); } orderLine.WeightInKg = totalWeightInKg; orderLine.StationOrderLineId = (int)Station.StationId; orderLine.StatusCode = (int)LocalDBStatusCode.Added; orderLinesList.Add(orderLine); } #endregion } try { db.Orders.Add(order); db.SaveChanges(); _order = order; MessageBox.Show("Order Saved"); if (sender != null) { this.Close(); } } catch (Exception ee) { MessageBox.Show("Order Failed"); } }
private void SaveButton_Click(object sender, EventArgs e) { var rows = dataGridViewReturned.Rows; if (rows.Count == 0) { MessageBox.Show("please enter some values"); return; } //var duePayments = LoadPreviousBill(); //if (duePayments != null) //{ // if (duePayments < ItemsReturnedValueField.Value) // { // var amountToBeReturned = ItemsReturnedValueField.Value - duePayments; // MessageBox.Show("You must atleast return Rs "+ amountToBeReturned); // return; // } //} if (AmountReturnedField.Value > AmountPaidField.Value || AmountReturnedField.Value > ItemsReturnedValueField.Value) { MessageBox.Show("Amount returned cannot be greater than amount paid or the items returned"); return; } #region ReadingDataGridReturned for (int i = 0; i < rows.Count; i++) { var row = rows[i]; var itemId = int.Parse(row.Cells["ItemIdColumn"].Value.ToString()); var kg = double.Parse(row.Cells["KiloColumn"].Value.ToString()); var grams = double.Parse(row.Cells["GramColumn"].Value.ToString()); double totalReturnedWeightInKg; if (grams == 0) { totalReturnedWeightInKg = kg; } else { totalReturnedWeightInKg = kg + (grams / 1000); } order.OrderLines.Where(aa => aa.ItemId == itemId).FirstOrDefault().WeightInKg -= totalReturnedWeightInKg; order.OrderLines.Where(aa => aa.ItemId == itemId).FirstOrDefault().StatusCode = (int)LocalDBStatusCode.Updated; } #endregion var orderPayment = db.OrderPaymentMades.Where(aa => aa.OrderId == order.OrderId && aa.StationOrderId == order.StationOrderId).FirstOrDefault(); if (orderPayment != null) { orderPayment.PaymentMade -= (int)AmountReturnedField.Value; orderPayment.StatusCode = (int)LocalDBStatusCode.Updated; } try { db.SaveChanges(); MessageBox.Show("Items returned"); this.Close(); } catch (Exception ee) { MessageBox.Show("un expected error occured \n" + ee.ToString()); } }
private void SaveButton_Click(object sender, EventArgs e) { try { FaridiaIronStoreEntities db = new FaridiaIronStoreEntities(); string oldPaymentItemName = "OldPaymentItem"; var oldPaymentItemCount = db.Items.Where(aa => aa.ItemName == oldPaymentItemName).Count(); Item oldPaymentItem; if (oldPaymentItemCount == 0) { oldPaymentItem = new Item(); oldPaymentItem.IsExtra = true; oldPaymentItem.ItemName = oldPaymentItemName; oldPaymentItem.StatusCode = (int)LocalDBStatusCode.Added; db.Items.Add(oldPaymentItem); db.SaveChanges(); } else { oldPaymentItem = db.Items.Where(aa => aa.ItemName == oldPaymentItemName).FirstOrDefault(); } Order order = new Order(); order.CustomerId = customerId; order.IsAdvanceOrder = false; order.IsDelivered = true; order.OrderDate = DateTime.Now; order.StationCustomerId = stationCustomerId; order.StationOrderId = (int)Station.StationId; order.StatusCode = (int)LocalDBStatusCode.Added; OrderLine orderLine = new OrderLine(); orderLine.ItemId = oldPaymentItem.ItemId; orderLine.PricePerUnit = (int)OldPaymentField.Value; orderLine.StationOrderLineId = (int)Station.StationId; orderLine.StatusCode = (int)LocalDBStatusCode.Added; orderLine.WeightInKg = 1; order.OrderLines.Add(orderLine); db.Orders.Add(order); db.SaveChanges(); MessageBox.Show("Your Payment has been added successfully"); int bill = LoadPreviousBill(); orderForm.UpdateOldPayments(bill); this.Close(); } catch (Exception ee) { MessageBox.Show("Un expected error has occured" + System.Environment.NewLine + ee.Message); } }