private void button1_Click(object sender, EventArgs e) { try { DBManager manager = new DBManager(); SqlConnection connection = manager.Connection(); TempOrderGateway aGateway = new TempOrderGateway(); List <TempOrder> aList = aGateway.GeList(); ReportDeliveryUI report = new ReportDeliveryUI(aList); report.ShowDialog(); System.Windows.Forms.DialogResult dialog = MessageBox.Show("Did you print the document?", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.Yes) { String deletequery = "delete from Temp_Order_Delivery"; SqlCommand command1 = new SqlCommand(deletequery, connection); connection.Open(); command1.ExecuteNonQuery(); string que = "DBCC CHECKIDENT (Temp_Order_Delivery,Reseed,0)"; command1 = new SqlCommand(que, connection); command1.ExecuteNonQuery(); string que1 = "set identity_insert Temp_Order_Delivery on"; command1 = new SqlCommand(que1, connection); command1.ExecuteNonQuery(); string insQuery = "insert into Deliveri_Memo_Counter values(@date)"; command1 = new SqlCommand(insQuery, connection); command1.Parameters.Clear(); command1.Parameters.AddWithValue("@date", DateTime.Now.Date); command1.ExecuteNonQuery(); memoNumver = GetLastMemoNumber(); } else if (dialog == DialogResult.No) { System.Windows.Forms.DialogResult dialog1 = MessageBox.Show("Are you want to print now?", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog1 == DialogResult.Yes) { report = new ReportDeliveryUI(aList); report.ShowDialog(); String deletequery = "delete from Temp_Order_Delivery"; SqlCommand command1 = new SqlCommand(deletequery, connection); connection.Open(); command1.ExecuteNonQuery(); string que = "DBCC CHECKIDENT (Temp_Order_Delivery,Reseed,0)"; command1 = new SqlCommand(que, connection); command1.ExecuteNonQuery(); string que1 = "set identity_insert Temp_Order_Delivery on"; command1 = new SqlCommand(que1, connection); command1.ExecuteNonQuery(); string insQuery = "insert into Deliveri_Memo_Counter values(@date)"; command1 = new SqlCommand(insQuery, connection); command1.Parameters.Clear(); command1.Parameters.AddWithValue("@date", DateTime.Now.Date); command1.ExecuteNonQuery(); memoNumver = GetLastMemoNumber(); DialogResult d2 = MessageBox.Show(" Print Sucessful! Are you want ot exit? ", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d2 == DialogResult.Yes) { this.Close(); } else if (d2 == DialogResult.No) { //OrderUI odUi=new OrderUI(); //odUi.ShowDialog(); } } else if (dialog1 == DialogResult.No) { this.Close(); } } } catch (Exception exception) { MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { DBManager manager = new DBManager(); SqlConnection connection = manager.Connection(); TempOrderGateway gateway = new TempOrderGateway(); List <TempOrder> orders = gateway.GetempOrders(); InvoiceUI invoice = new InvoiceUI(orders); invoice.ShowDialog(); System.Windows.Forms.DialogResult dialog = MessageBox.Show("Did you print the document?", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.Yes) { String deletequery = "delete from Temp_Order_Hold"; SqlCommand command1 = new SqlCommand(deletequery, connection); connection.Open(); command1.ExecuteNonQuery(); string que = "DBCC CHECKIDENT (Temp_Order_Hold,Reseed,0)"; command1 = new SqlCommand(que, connection); command1.ExecuteNonQuery(); string que1 = "set identity_insert Temp_Order_Hold on"; command1 = new SqlCommand(que1, connection); command1.ExecuteNonQuery(); string insQuery = "insert into Order_Memo_Counter values(@date)"; command1 = new SqlCommand(insQuery, connection); command1.Parameters.Clear(); command1.Parameters.AddWithValue("@date", DateTime.Now.Date); command1.ExecuteNonQuery(); memoNumver = GetLastMemoNumber(); //string insQuery = "insert into Due_Memo_Counter values(@date)"; //command1 = new SqlCommand(insQuery, connection); //command1.Parameters.Clear(); //command1.Parameters.AddWithValue("@date", DateTime.Now.Date); //command1.ExecuteNonQuery(); //memoNumver = GetLastMemoNumber(); } else if (dialog == DialogResult.No) { System.Windows.Forms.DialogResult dialog1 = MessageBox.Show("Are you want to print now?", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog1 == DialogResult.Yes) { invoice = new InvoiceUI(orders); invoice.ShowDialog(); String deletequery = "delete from Temp_Order_Hold"; SqlCommand command1 = new SqlCommand(deletequery, connection); connection.Open(); command1.ExecuteNonQuery(); string que = "DBCC CHECKIDENT (Temp_Order_Hold,Reseed,0)"; command1 = new SqlCommand(que, connection); command1.ExecuteNonQuery(); string que1 = "set identity_insert Temp_Order_Hold on"; command1 = new SqlCommand(que1, connection); command1.ExecuteNonQuery(); string insQuery = "insert into Order_Memo_Counter values(@date)"; command1 = new SqlCommand(insQuery, connection); command1.Parameters.Clear(); command1.Parameters.AddWithValue("@date", DateTime.Now.Date); command1.ExecuteNonQuery(); memoNumver = GetLastMemoNumber(); DialogResult d2 = MessageBox.Show(" Print Sucessful! Are you want ot exit? ", "Print Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d2 == DialogResult.Yes) { this.Close(); } else if (d2 == DialogResult.No) { //OrderUI odUi=new OrderUI(); //odUi.ShowDialog(); } } else if (dialog1 == DialogResult.No) { this.Close(); } } }
private void DeliveryButton(object sender, EventArgs e) { try { if (dueTextBox.Text.Equals(payingAmountTextBOX.Text)) { double due, pay, final_Due; int quantity, serial_No; double unitprice, advance, BuyUnitPrice; double a, b; a = Convert.ToDouble(dueTextBox.Text); b = Convert.ToDouble(payingAmountTextBOX.Text); if (dueTextBox.Text.Equals("") && payingAmountTextBOX.Text.Equals("")) { MessageBox.Show("There are no order for delivery.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (a < b) { MessageBox.Show("Please check the paying amount.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { due = Convert.ToDouble(dueTextBox.Text); pay = Convert.ToDouble(payingAmountTextBOX.Text); final_Due = due - pay; BuyUnitPrice = Convert.ToDouble(buyingUnitPriceTextBox.Text); quantity = Convert.ToInt16(bookQuantityTextBOx.Text); unitprice = Convert.ToDouble(bookUnitPriceTextBOx.Text); advance = Convert.ToDouble(advanceTextBox.Text); serial_No = Convert.ToInt16(serialTextBox.Text); string print = bookPrintTextBox.Text; DBManager manager = new DBManager(); SqlConnection connection = manager.Connection(); string insertQuery = "INSERT INTO Delivery_Report values(@serial,@cname,@phone,@bookName,@writer,@edition,@print,@quantity,@buyUnitprice,@unitpricecell,@advance,@due,@payingAmount,@finaldue,@date)"; SqlCommand command = new SqlCommand(insertQuery, connection); connection.Open(); command.Parameters.Clear(); command.Parameters.Add("@serial", serialTextBox.Text); command.Parameters.Add("@cname", customerNameTextBox.Text); command.Parameters.Add("@phone", customerMobileTextBox.Text); command.Parameters.Add("@bookName", bookNameTextBox.Text); command.Parameters.Add("@writer", writerNameTextBox.Text); command.Parameters.Add("@edition", bookEditionTextBox.Text); command.Parameters.Add("@print", bookPrintTextBox.Text); command.Parameters.Add("@quantity", quantity); command.Parameters.Add("@buyUnitprice", Convert.ToDouble(BuyUnitPrice)); command.Parameters.Add("@unitpricecell", unitprice); command.Parameters.Add("@advance", advance); command.Parameters.Add("@due", due); command.Parameters.Add("@payingAmount", pay); command.Parameters.Add("@finaldue", final_Due); command.Parameters.Add("@date", DateTime.Now.ToShortDateString()); command.ExecuteNonQuery(); DBManager manager6 = new DBManager(); SqlConnection connection6 = manager6.Connection(); string selectQuery6 = "insert into Due_Collection values(@pay,@empty,@payConleection,@date)"; SqlCommand cmd6 = new SqlCommand(selectQuery6, connection6); connection6.Open() ; cmd6.Parameters.Clear(); cmd6.Parameters.Add("@pay", "0"); cmd6.Parameters.Add("@empty", "0"); cmd6.Parameters.AddWithValue("@payConleection", pay); cmd6.Parameters.Add("@date", DateTime.Now.ToShortDateString()); cmd6.ExecuteNonQuery(); connection.Close(); string deleteQuery = "delete from Orders where Order_No='" + serial_No + "'"; SqlCommand command1 = new SqlCommand(deleteQuery, connection); connection.Open(); int x = command1.ExecuteNonQuery(); MessageBox.Show(customerNameTextBox.Text + " paid his/her due.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); connection.Close(); //update books string name = bookNameTextBox.Text; string writer = writerNameTextBox.Text; string edition = bookEditionTextBox.Text; String selectQ = "select Quantiy,B_Unit_Price from Books where Name=@name and Edition=@edition and Writer=@writer"; SqlCommand sletCom = new SqlCommand(selectQ, connection); connection.Open(); sletCom.Parameters.Clear(); sletCom.Parameters.AddWithValue("@name", name); sletCom.Parameters.AddWithValue("@edition", edition); sletCom.Parameters.AddWithValue("@writer", writer); SqlDataReader reader = sletCom.ExecuteReader(); while (reader.Read()) { int quantity4 = Convert.ToInt16(reader[0]); double unitprice5 = Convert.ToDouble(reader[1]); connection.Close(); int quantityReudceBook, final_quantity; quantityReudceBook = Convert.ToInt16(bookQuantityTextBOx.Text); final_quantity = quantity4 - quantityReudceBook; double T_Price = final_quantity * unitprice5; string updateQuery = "UPDATE Books set Quantiy=@quantity,Total_Price=@totalPrice where Name=@name and Edition=@edition and Writer=@writer"; SqlCommand upCommand = new SqlCommand(updateQuery, connection); upCommand.Parameters.Clear(); upCommand.Parameters.AddWithValue("@quantity", final_quantity); upCommand.Parameters.AddWithValue("@totalPrice", T_Price); upCommand.Parameters.AddWithValue("@name", name); upCommand.Parameters.AddWithValue("@edition", edition); upCommand.Parameters.AddWithValue("@writer", writer); connection.Open(); int s = upCommand.ExecuteNonQuery(); MessageBox.Show("Updated", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); //temp order delivery report save TempOrder anOrder = new TempOrder(serialTextBox.Text, customerNameTextBox.Text, customerMobileTextBox.Text, bookNameTextBox.Text, writerNameTextBox.Text, bookEditionTextBox.Text, bookPrintTextBox.Text, Convert.ToInt16(bookQuantityTextBOx.Text), Convert.ToDouble(bookUnitPriceTextBOx.Text ), Convert.ToDouble(Convert.ToInt16(bookQuantityTextBOx.Text) * Convert.ToDouble(bookUnitPriceTextBOx.Text)), Convert.ToDouble(advanceTextBox.Text), final_Due, Convert.ToDouble(payingAmountTextBOX.Text), memoNumver); TempOrderGateway gateway = new TempOrderGateway(); gateway.SaveDeliveryReport(anOrder); GetAllOrders(); GetAllOrders1(); ClearAllTextBox(); connection.Close(); return; } } } else { double due, pay, final_Due; int quantity, serial_No; double unitprice, advance, BuyUnitPrice; quan = Convert.ToInt16(bookQuantityTextBOx.Text); double a, b; a = Convert.ToDouble(dueTextBox.Text); b = Convert.ToDouble(payingAmountTextBOX.Text); if (dueTextBox.Text.Equals("0") || payingAmountTextBOX.Text.Equals("0")) { final_Due = 0; } else if (a < b) { MessageBox.Show("Please check the paying amount.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { due = Convert.ToDouble(dueTextBox.Text); pay = Convert.ToDouble(payingAmountTextBOX.Text); final_Due = due - pay; BuyUnitPrice = Convert.ToDouble(buyingUnitPriceTextBox.Text); quantity = Convert.ToInt16(bookQuantityTextBOx.Text); unitprice = Convert.ToDouble(bookUnitPriceTextBOx.Text); advance = Convert.ToDouble(advanceTextBox.Text); serial_No = Convert.ToInt16(serialTextBox.Text); DBManager manager = new DBManager(); SqlConnection connection = manager.Connection(); string insertQuery = "INSERT INTO Delivery_Report values(@serial,@cname,@phone,@bookName,@writer,@edition,@print,@quantity,@buyUnitprice,@unitpricecell,@advance,@due,@payingAmount,@finaldue,@date)"; SqlCommand command = new SqlCommand(insertQuery, connection); connection.Open(); command.Parameters.Clear(); command.Parameters.Add("@serial", serialTextBox.Text); command.Parameters.Add("@cname", customerNameTextBox.Text); command.Parameters.Add("@phone", customerMobileTextBox.Text); command.Parameters.Add("@bookName", bookNameTextBox.Text); command.Parameters.Add("@writer", writerNameTextBox.Text); command.Parameters.Add("@edition", bookEditionTextBox.Text); command.Parameters.Add("@print", bookPrintTextBox.Text); command.Parameters.Add("@quantity", quantity); command.Parameters.Add("@buyUnitprice", Convert.ToDouble(BuyUnitPrice)); command.Parameters.Add("@unitpricecell", unitprice); command.Parameters.Add("@advance", advance); command.Parameters.Add("@due", due); command.Parameters.Add("@payingAmount", pay); command.Parameters.Add("@finaldue", final_Due); command.Parameters.Add("@date", DateTime.Now.ToShortDateString()); command.ExecuteNonQuery(); connection.Close(); DBManager manager5 = new DBManager(); SqlConnection connection5 = manager5.Connection(); string selectQuery5 = "SELECT Quantity,Unit_Price From Orders where Order_No=@serial"; SqlCommand cmd5 = new SqlCommand(selectQuery5, connection5); cmd5.Parameters.Clear(); cmd5.Parameters.AddWithValue("@serial", serial_No); connection5.Open() ; SqlDataReader reader5 = cmd5.ExecuteReader(); while (reader5.Read()) { string q = reader5[0].ToString(); string r = reader5[1].ToString(); if (q.Equals("") && r.Equals("")) { qunatityOfRemaingBook = 0; unit_Price = 0; } else { qunatityOfRemaingBook = Convert.ToInt16(q); unit_Price = Convert.ToDouble(r); } } connection.Close(); //Due Collection table Update double s_due = Convert.ToDouble(dueTextBox.Text) - Convert.ToDouble(payingAmountTextBOX.Text); DBManager manager6 = new DBManager(); SqlConnection connection6 = manager6.Connection(); string selectQuery6 = "insert into Due_Collection values(@pay,@s_due,@payCollection,@date)"; SqlCommand cmd6 = new SqlCommand(selectQuery6, connection6); connection6.Open() ; cmd6.Parameters.Clear(); cmd6.Parameters.Add("@pay", "0"); cmd6.Parameters.Add("@s_due", s_due); cmd6.Parameters.AddWithValue("@payCollection", pay); cmd6.Parameters.Add("@date", DateTime.Now.ToShortDateString()); cmd6.ExecuteNonQuery(); int sa = qunatityOfRemaingBook - quan; string deleteQuery = "Update Orders set Quantity=@quantity,Total_price=@totalprice, Due=@due where Order_No=@serial"; SqlCommand command1 = new SqlCommand(deleteQuery, connection); command1.Parameters.Clear(); command1.Parameters.AddWithValue("@quantity", sa); command1.Parameters.AddWithValue("@totalprice", (sa * unit_Price)); command1.Parameters.AddWithValue("@due", final_Due); command1.Parameters.AddWithValue("@serial", serial_No); connection.Open(); int x = command1.ExecuteNonQuery(); MessageBox.Show(customerNameTextBox.Text + " Your current due is " + final_Due + ".", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); connection.Close(); //books update string name = (bookNameTextBox.Text).Trim(); string writer = writerNameTextBox.Text; string edition = bookEditionTextBox.Text; string selectQ = "select Quantiy,B_Unit_Price from Books where Name=@name and Edition=@edition and Writer=@writer"; SqlCommand sletCom = new SqlCommand(selectQ, connection); sletCom.Parameters.Clear(); sletCom.Parameters.AddWithValue("@name", name); sletCom.Parameters.AddWithValue("@edition", edition); sletCom.Parameters.AddWithValue("@writer", writer); connection.Open(); SqlDataReader reader = sletCom.ExecuteReader(); while (reader.Read()) { int quantity4 = Convert.ToInt16(reader[0]); double unitprice5 = Convert.ToDouble(reader[1]); connection.Close(); int quantityReudceBook, final_quantity; quantityReudceBook = Convert.ToInt16(bookQuantityTextBOx.Text); final_quantity = quantity4 - quantityReudceBook; double T_Price = final_quantity * unitprice5; string updateQuery = "UPDATE Books set Quantiy=@finalQuantity,Total_Price=@totalprice where Name=@name and Edition=@edition and Writer=@writer"; SqlCommand upCommand = new SqlCommand(updateQuery, connection); upCommand.Parameters.Clear(); upCommand.Parameters.AddWithValue("@finalQuantity", final_quantity); upCommand.Parameters.AddWithValue("@totalprice", T_Price); upCommand.Parameters.AddWithValue("@name", name); upCommand.Parameters.AddWithValue("@edition", edition); upCommand.Parameters.AddWithValue("@writer", writer); connection.Open(); upCommand.ExecuteNonQuery(); //for partial pay TempOrder anOrder = new TempOrder(serialTextBox.Text, customerNameTextBox.Text, customerMobileTextBox.Text, bookNameTextBox.Text, writerNameTextBox.Text, bookEditionTextBox.Text, bookPrintTextBox.Text, Convert.ToInt16(bookQuantityTextBOx.Text), Convert.ToDouble(bookUnitPriceTextBOx.Text ), Convert.ToDouble(Convert.ToInt16(bookQuantityTextBOx.Text) * Convert.ToDouble(bookUnitPriceTextBOx.Text)), Convert.ToDouble(advanceTextBox.Text), final_Due, Convert.ToDouble(payingAmountTextBOX.Text), memoNumver); TempOrderGateway gateway = new TempOrderGateway(); gateway.SaveDeliveryReport(anOrder); GetAllOrders(); GetAllOrders1(); ClearAllTextBox(); connection.Close(); MessageBox.Show("Updated", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } } } catch (Exception formatException) { MessageBox.Show(formatException.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//save an Order private void orderAcceptButton_Click(object sender, EventArgs e) { try { OrderGateway gateway = new OrderGateway(); Order anOrder = new Order(); anOrder.CustomerName = customerNameTextBox.Text; anOrder.CustomerPhone = customerMobileTextBox.Text; anOrder.BookName = bookNameTextBox.Text; anOrder.WriterName = writerNameTextBox.Text; anOrder.Edition = bookEditionTextBox.Text; anOrder.TypeOfBook = typeOfBookTextBox.Text; anOrder.BookPrint = bookPrintTextbox.Text; anOrder.BuyUnitPrice = Convert.ToDouble(buyingUnitPriceTextBox.Text); string quantiy = bookQuantityTextBOx.Text; anOrder.Quantity = Convert.ToInt16(quantiy); anOrder.UnitPrice = Convert.ToDouble(bookUnitPriceTextBOx.Text); anOrder.Advance = Convert.ToDouble(advanceTextBox.Text); anOrder.SupplyDate = dateTimePicker1.Text; string st = gateway.SaveOrder(anOrder); ////InvoiceUI invoice=new InvoiceUI(serialTextBox.Text,customerNameTextBox.Text,customerMobileTextBox.Text,bookNameTextBox.Text,writerNameTextBox.Text,bookEditionTextBox.Text,typeOfBookTextBox.Text,bookPrintTextbox.Text,bookQuantityTextBOx.Text,bookUnitPriceTextBOx.Text,advanceTextBox.Text,dueTextBox.Text,dateTimePicker1.Text); //invoice.ShowDialog(); TempOrder aOrder = new TempOrder(); aOrder.SerialNo = serialTextBox.Text; aOrder.CustomerName = customerNameTextBox.Text; aOrder.MobileNo = customerMobileTextBox.Text; aOrder.BookName = bookNameTextBox.Text; aOrder.WriterName = writerNameTextBox.Text; aOrder.Edition = bookEditionTextBox.Text; aOrder.Type = typeOfBookTextBox.Text; aOrder.Print = bookPrintTextbox.Text; aOrder.Quantity = Convert.ToInt16(bookQuantityTextBOx.Text); aOrder.Unitprice = Convert.ToDouble(bookUnitPriceTextBOx.Text); aOrder.Total = (Convert.ToInt16(bookQuantityTextBOx.Text) * Convert.ToDouble(bookUnitPriceTextBOx.Text)); aOrder.Advance = Convert.ToDouble(advanceTextBox.Text); aOrder.Due = Convert.ToDouble(dueTextBox.Text); aOrder.SupplyDate = dateTimePicker1.Text; aOrder.MemoNumber = memoNumver; TempOrderGateway gateway1 = new TempOrderGateway(); gateway1.SaveTempOrer(aOrder); MessageBox.Show(st, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearALLtextBox(); LoadAllBook(); serialTextBox.Text = LastAddedInvestlNo().ToString(); CustomerNamteSuggestion(); AtocompleteTextBox(); } catch (Exception exception) { MessageBox.Show(exception.Message); //MessageBox.Show("Please fill every fields properly.", "Error", MessageBoxButtons.OK, // MessageBoxIcon.Error); } }