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