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);
}
}
