private void buttonSearchOrder_Click(object sender, EventArgs e)
{
Order Or = OrdersDA.SearchN(Convert.ToInt32(textBoxOrderSearcher.Text));
if (Or != null)
{
textBoxOrderNumber.Text = Or.OrdernUmber.ToString();
dateTimePickerOrder.Text = Or.OrderDate;
dateTimePickerShipping.Text = Or.ShippingDate;
textBoxclientname.Text = Or.ClientNumber;
textBoxbooktitle.Text = Or.BookName;
textBoxOrderQuantity.Text = Or.Quantity.ToString();
textBoxUnitPrice.Text = Or.unit.ToString();
textBoxSubtotal.Text = Or.Subtotal.ToString();
textBoxGST.Text = Or.Gst.ToString();
textBoxPST.Text = Or.Pst.ToString();
textBoxtotal.Text = Or.total.ToString();
textBoxOrderSearcher.Clear();
}
else
{
MessageBox.Show("User not Found!");
textBoxOrderSearcher.Clear();
textBoxOrderSearcher.Focus();
}
}
private void buttonUpdateEmployee_Click(object sender, EventArgs e)
{
if ((textBoxclientname.Text == "") || (textBoxbooktitle.Text == "") || (textBoxOrderQuantity.Text == "") || (textBoxUnitPrice.Text == "") || (textBoxSubtotal.Text == "") || (textBoxGST.Text == "") || (textBoxPST.Text == "") || (textBoxtotal.Text == ""))
{
MessageBox.Show("Please full fill all the fields", "Missing Data");
return;
}
else
{
}
{
Order Us = new Order();
Us.OrdernUmber = Convert.ToInt32(textBoxOrderNumber.Text);
Us.OrderDate = dateTimePickerOrder.Text;
Us.ShippingDate = dateTimePickerShipping.Text;
Us.ClientNumber = textBoxclientname.Text;
Us.BookName = textBoxbooktitle.Text;
Us.Quantity = Convert.ToSByte(textBoxOrderQuantity.Text);
Us.unit = Convert.ToSByte(textBoxUnitPrice.Text);
Us.Subtotal = Convert.ToSByte(textBoxSubtotal.Text);
Us.Gst = Convert.ToSByte(textBoxGST.Text);
Us.Pst = Convert.ToSByte(textBoxPST.Text);
Us.unit = Convert.ToSByte(textBoxtotal.Text);
DialogResult ans = MessageBox.Show("Do you really want to update this User?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (ans == DialogResult.Yes)
{
OrdersDA.Update(Us);
MessageBox.Show("User record has been updated successfully", "Confirmation");
}
textBoxOrderNumber.Enabled = true;
ClearAll();
}
}
private void buttonListEmployee_Click(object sender, EventArgs e)
{
listViewOrder.Items.Clear();
OrdersDA.ListOrder(listViewOrder);
}
private void buttonSaveEmployee_Click(object sender, EventArgs e)
{
if ((textBoxclientname.Text == "") || (textBoxbooktitle.Text == "") || (textBoxOrderQuantity.Text == "") || (textBoxUnitPrice.Text == "") || (textBoxSubtotal.Text == "") || (textBoxGST.Text == "") || (textBoxPST.Text == "") || (textBoxtotal.Text == ""))
{
MessageBox.Show("Please full fill all the fields", "Missing Data");
ClearAll();
return;
}
else
{
Client client = ClientsDA.SearchNM(textBoxclientname.Text);
Books book = BooksDA.SearchTitle(textBoxbooktitle.Text);
string qtfh = textBoxclientname.Text;
string asda = textBoxbooktitle.Text;
int lalala = Convert.ToInt32(textBoxOrderQuantity.Text);
if (book == null)
{
MessageBox.Show("Wrong Information book, try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (client == null)
{
MessageBox.Show("Wrong Information client, try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (book.BookQOH < Convert.ToInt32(textBoxOrderQuantity.Text))
{
MessageBox.Show("The inventory does not have that quantity of products", "Missing Product");
ClearAll();
return;
}
else
{
Order Or = new Order();
if ((client.Name == textBoxclientname.Text) && (book.Title.ToString() == textBoxbooktitle.Text) && (book.BookQOH < Convert.ToInt32(textBoxOrderQuantity.Text)))
{
Or.OrdernUmber = Convert.ToInt32(textBoxOrderNumber.Text);
Or.OrderDate = dateTimePickerOrder.Text;
Or.ShippingDate = dateTimePickerShipping.Text;
Or.ClientNumber = textBoxclientname.Text;
Or.BookName = textBoxbooktitle.Text;
Or.Quantity = Convert.ToInt32(textBoxOrderQuantity.Text);
Or.unit = Convert.ToInt32(textBoxUnitPrice.Text);
Or.Subtotal = Convert.ToInt32(textBoxSubtotal.Text);
Or.Gst = Convert.ToInt32(textBoxGST.Text);
Or.Pst = Convert.ToInt32(textBoxPST.Text);
Or.total = Convert.ToInt32(textBoxtotal.Text);
OrdersDA.Save(Or);
ClearAll();
}
}
}
}
public decimal Delete_Order(decimal order_id)
{
OrdersDA Obj_da = new OrdersDA();
try
{
return(Obj_da.DeleteOrder(order_id));
}
catch (Exception ex)
{
Common.log.Error(ex.ToString());
return(-1);
}
}
public decimal Update_Order(OrderInfo Obj_Info)
{
OrdersDA Obj_da = new OrdersDA();
try
{
return(Obj_da.UpdateOrder(Obj_Info));
}
catch (Exception ex)
{
Common.log.Error(ex.ToString());
return(-1);
}
}
public OrderInfo GetOrderById(decimal Order_Id)
{
OrdersDA Obj_da = new OrdersDA();
OrderInfo Obj_Info = new OrderInfo();
try
{
var ds = Obj_da.GetOrderByID(Order_Id);
Obj_Info = CBO <OrderInfo> .FillObject_From_DataSet(ds);
}
catch (Exception ex)
{
Common.log.Error(ex.ToString());
}
return(Obj_Info);
}
public List <OrderInfo> Order_Search(string p_keySearch, string p_from, string p_to, ref decimal p_total_record)
{
OrdersDA Obj_da = new OrdersDA();
List <OrderInfo> List_Obj = new List <OrderInfo>();
try
{
var ds = Obj_da.Order_Search(p_keySearch, p_from, p_to, ref p_total_record);
List_Obj = CBO <OrderInfo> .FillCollectionFromDataSet(ds);
}
catch (Exception ex)
{
Common.log.Error(ex.ToString());
}
return(List_Obj);
}
public List <OrderInfo> GetAll_Order()
{
OrdersDA Obj_da = new OrdersDA();
List <OrderInfo> List_Obj = new List <OrderInfo>();
try
{
var ds = Obj_da.GetAll_Order();
List_Obj = CBO <OrderInfo> .FillCollectionFromDataSet(ds);
}
catch (Exception ex)
{
Common.log.Error(ex.ToString());
}
return(List_Obj);
}
/// <summary>
/// we are not passing any parameters since we don't need any thing back from database.
/// </summary>
/// <returns></returns>
public DataTable BindGridView()
{
OrdersDA orderObj = new OrdersDA();
return(orderObj.BindGridView());
}
private void buttonDeleteEmployee_Click(object sender, EventArgs e)
{
OrdersDA.Delete(textBoxOrderNumber.Text);
MessageBox.Show(" Order record has been deleted successfully", "Confirmation");
}
public OrderController()
{
_orderDa = new OrdersDA("#");
}
