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("#"); }