public string SaveOrder(Order anOrder)
{
try
{
if (anOrder.Quantity <= 0)
{
MessageBox.Show("Enter the book quantity", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (anOrder.Advance < 0)
{
MessageBox.Show("Enter the advance ammount", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
//int quantity =;
double total = anOrder.Quantity*anOrder.UnitPrice;
double due = total - anOrder.Advance;
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string insertQuery = "INSERT INTO Orders values(@name,@phone,@bname,@bwriter,@bEdition,@type,@bPrint,@buyUnitprice,@bQuantity,@unitprice,@total,@advance,@due,@odrderDate,@supplyDate)";
//string insertQuery = "INSERT INTO Orders values('" + anOrder.CustomerName + "','" +
// anOrder.CustomerPhone + "','" + anOrder.BookName + "','" + anOrder.WriterName +
// "','" + anOrder.Edition + "','" + anOrder.BookPrint + "','" + anOrder.BuyUnitPrice + "','" + anOrder.Quantity + "','" + anOrder.UnitPrice +
// "','" + total + "','" + anOrder.Advance + "','" + due + "','" +
// DateTime.Now.ToShortDateString() + "','" + anOrder.SupplyDate + "')";
SqlCommand insertCommand = new SqlCommand(insertQuery, connection);
connection.Open();
insertCommand.Parameters.Clear();
insertCommand.Parameters.AddWithValue("@name", anOrder.CustomerName);
insertCommand.Parameters.AddWithValue("@phone", anOrder.CustomerPhone);
insertCommand.Parameters.AddWithValue("@bname", anOrder.BookName);
insertCommand.Parameters.AddWithValue("@bwriter", anOrder.WriterName);
insertCommand.Parameters.AddWithValue("@bEdition", anOrder.Edition);
insertCommand.Parameters.AddWithValue("@type", anOrder.TypeOfBook);
insertCommand.Parameters.AddWithValue("@bPrint", anOrder.BookPrint);
insertCommand.Parameters.AddWithValue("@buyUnitprice", anOrder.BuyUnitPrice);
insertCommand.Parameters.AddWithValue("@bQuantity", anOrder.Quantity);
insertCommand.Parameters.AddWithValue("@unitprice", anOrder.UnitPrice);
insertCommand.Parameters.AddWithValue("@total", total);
insertCommand.Parameters.AddWithValue("@advance", anOrder.Advance);
insertCommand.Parameters.AddWithValue("@due", due);
insertCommand.Parameters.AddWithValue("@odrderDate", DateTime.Now.ToShortDateString());
insertCommand.Parameters.AddWithValue("@supplyDate", anOrder.SupplyDate);
int i = insertCommand.ExecuteNonQuery();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
return " Order Saved";
}
public string SaveOrder(Order anOrder)
{
try
{
if (anOrder.Quantity <= 0)
{
MessageBox.Show("Enter the book quantity", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (anOrder.Advance < 0)
{
MessageBox.Show("Enter the advance ammount", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
//int quantity =;
double total = anOrder.Quantity*anOrder.UnitPrice;
double due = total - anOrder.Advance;
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string insertQuery = "INSERT INTO Orders values('" + anOrder.CustomerName + "','" +
anOrder.CustomerPhone + "','" + anOrder.BookName + "','" + anOrder.WriterName +
"','" + anOrder.Edition + "','"+anOrder.BuyUnitPrice+"','" + anOrder.Quantity + "','" + anOrder.UnitPrice +
"','" + total + "','" + anOrder.Advance + "','" + due + "','" +
DateTime.Now.ToShortDateString() + "','" + anOrder.SupplyDate + "')";
SqlCommand insertCommand = new SqlCommand(insertQuery, connection);
connection.Open();
int i = insertCommand.ExecuteNonQuery();
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
return " Order Saved";
}
public void AllOrder()
{
try
{
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders";
SqlCommand cmd = new SqlCommand(selectQuery, connection);
connection.Open();
order2 = new List<Order>();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string bookName = reader[0].ToString();
string writerName = reader[1].ToString();
string edition = reader[2].ToString();
string qu = reader[3].ToString();
int quantity = Convert.ToInt16(qu);
Order anOrder = new Order();
anOrder.BookName = bookName;
anOrder.WriterName = writerName;
anOrder.Edition = edition;
anOrder.Quantity = quantity;
order2.Add(anOrder);
}
}
catch (SqlException exception)
{
MessageBox.Show(exception.Message);
}
}
//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.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);
MessageBox.Show(st,"Information",MessageBoxButtons.OK,MessageBoxIcon.Information);
ClearALLtextBox();
LoadAllBook();
serialTextBox.Text = LastAddedInvestlNo().ToString();
}
catch (Exception)
{
MessageBox.Show("Please fill every fields properly.", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void button6_Click_1(object sender, EventArgs e)
{
try
{
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders";
SqlCommand cmd = new SqlCommand(selectQuery, connection);
connection.Open();
List<Order> orders = new List<Order>();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string bookName = reader[0].ToString();
string writerName = reader[1].ToString();
string edition = reader[2].ToString();
string qu = reader[3].ToString();
int quantity = Convert.ToInt16(qu);
Order anOrder = new Order();
anOrder.BookName = bookName;
anOrder.WriterName = writerName;
anOrder.Edition = edition;
anOrder.Quantity = quantity;
orders.Add(anOrder);
}
QuantitySelect aQuantitySelect = new QuantitySelect(orders);
aQuantitySelect.ShowDialog();
}
catch (SqlException exception)
{
MessageBox.Show(exception.Message);
}
}
//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);
}
}
