void PopulateListViewOrders() { try { OrderCount = 0; listViewOrder.Items.Clear(); cmbOrderIds.Items.Clear(); App_Data.POSDataSet.OrdersDataTable myOrdersTb = new App_Data.POSDataSet.OrdersDataTable(); myOrdersAd.FillOrderDatewiseBy(myOrdersTb, Convert.ToDateTime(DateTime.Now.ToShortDateString())); string[] OrderCollection = new string[3]; string OrderType = ""; foreach (DataRow myRow in myOrdersTb.Rows) { if (myRow["order_type_id"].ToString() == "1") { OrderType = "Normal"; } else { OrderType = "Delivery"; } OrderCollection[0] = (++OrderCount).ToString(); OrderCollection[1] = OrderType; OrderCollection[2] = myRow["total_amount"].ToString(); cmbOrderIds.Items.Add(myRow["order_id"].ToString()); ListViewItem myIt = new ListViewItem(OrderCollection); listViewOrder.Items.Add(myIt); } } catch (Exception exc) { MessageBox.Show("Error in Populating List View\n" + exc.Message); } }
private void btnAddtoDb_Click(object sender, EventArgs e) { count = 1; int OrderId = 0; App_Data.POSDataSet.OrdersDataTable myOrdTb = new App_Data.POSDataSet.OrdersDataTable(); if (listViewSaleItems.Items.Count < 1) { MessageBox.Show("No Item Inserted"); return; } try { int OrderType = 1; if (chkDelivery.Checked == true) OrderType = 2; myOrdersAd.InsertOrderQuery(OrderType, Convert.ToInt32(lblPrice.Text), Convert.ToDateTime(DateTime.Now.ToShortDateString())); myOrdersAd.Fill(myOrdTb); OrderId = Convert.ToInt32(myOrdTb.Rows[myOrdTb.Rows.Count-1][0].ToString()); foreach (ListViewItem myItem in listViewSaleItems.Items) { myOrderItemsAd.InsertOrderedItemQuery(myItem.SubItems[1].Text, OrderId, Convert.ToInt32(myItem.SubItems[3].Text), Convert.ToInt32(myItem.SubItems[2].Text)); } PopulateListViewOrders(); listViewSaleItems.Items.Clear(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void btnAddtoDb_Click(object sender, EventArgs e) { count = 1; int OrderId = 0; App_Data.POSDataSet.OrdersDataTable myOrdTb = new App_Data.POSDataSet.OrdersDataTable(); if (listViewSaleItems.Items.Count < 1) { MessageBox.Show("No Item Inserted"); return; } try { int OrderType = 1; if (chkDelivery.Checked == true) { OrderType = 2; } myOrdersAd.InsertOrderQuery(OrderType, Convert.ToInt32(lblPrice.Text), Convert.ToDateTime(DateTime.Now.ToShortDateString())); myOrdersAd.Fill(myOrdTb); OrderId = Convert.ToInt32(myOrdTb.Rows[myOrdTb.Rows.Count - 1][0].ToString()); foreach (ListViewItem myItem in listViewSaleItems.Items) { myOrderItemsAd.InsertOrderedItemQuery(myItem.SubItems[1].Text, OrderId, Convert.ToInt32(myItem.SubItems[3].Text), Convert.ToInt32(myItem.SubItems[2].Text)); } PopulateListViewOrders(); listViewSaleItems.Items.Clear(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
void PopulateListViewOrders() { try { OrderCount = 0; listViewOrder.Items.Clear(); cmbOrderIds.Items.Clear(); App_Data.POSDataSet.OrdersDataTable myOrdersTb = new App_Data.POSDataSet.OrdersDataTable(); myOrdersAd.FillOrderDatewiseBy(myOrdersTb, Convert.ToDateTime(DateTime.Now.ToShortDateString())); string[] OrderCollection = new string[3]; string OrderType = ""; foreach (DataRow myRow in myOrdersTb.Rows) { if (myRow["order_type_id"].ToString() == "1") OrderType = "Normal"; else OrderType = "Delivery"; OrderCollection[0] = (++OrderCount).ToString(); OrderCollection[1] = OrderType; OrderCollection[2] = myRow["total_amount"].ToString(); cmbOrderIds.Items.Add(myRow["order_id"].ToString()); ListViewItem myIt = new ListViewItem(OrderCollection); listViewOrder.Items.Add(myIt); } } catch (Exception exc) { MessageBox.Show("Error in Populating List View\n" + exc.Message); } }