private void btn_save_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
for (int a = 0; a < dataGridView1.Rows.Count; a++)
{
string item = (dataGridView1.Rows[a].Cells["cal_item_name"].Value.ToString());
decimal quantity = Convert.ToDecimal(dataGridView1.Rows[a].Cells["cal_qty"].Value.ToString());
decimal cost = Convert.ToDecimal(dataGridView1.Rows[a].Cells["cal_cost"].Value.ToString());
decimal total = Convert.ToDecimal(dataGridView1.Rows[a].Cells["cal_total"].Value.ToString());
DataTable dt = blord.getallbyitem_name(item);
if (dt.Rows.Count > 0)
{
im.ingredientManage(Convert.ToInt32(dt.Rows[0]["item_id"]), quantity);//item sales wise stock decrease
int insert = blim.StockWasteInsert(Convert.ToInt32(dt.Rows[0]["item_id"]), quantity, Convert.ToDateTime(today));
MessageBox.Show("Successfully Inserted Waste", "Insert Data Alert !!");
dataGridView1.Rows.Clear();
}
}
}
else
{
MessageBox.Show("Nothing To Save", "No Data Alert !!");
}
}
private void cbo_item_name_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbo_item_name.Text != "" && cbo_item_name.Text != "Choose One")
{
DataTable dt = blod.getallbyitem_name(cbo_item_name.Text);
if (dt.Rows.Count > 0)
{
txtitemprice.Text = dt.Rows[0]["item_price"].ToString();
txt_kot_type.Text = dt.Rows[0]["kot_print"].ToString();
}
}
}
public void datagrid_Load()
{
if (datagridview_item_name.Count > 0)
{
dataGridView1.Rows.Clear();
for (int i = 0; i < datagridview_item_name.Count; i++)
{
int abc = dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells["cal_item_name"].Value = datagridview_item_name[i];
dataGridView1.Rows[i].Cells["cal_qty"].Value = datagridview_quantity[i];
DataTable dt1 = blord.getallbyitem_name(datagridview_item_name[i]);
if (dt1.Rows.Count > 0)
{
int item_id = Convert.ToInt32(dt1.Rows[0]["item_id"].ToString());
dataGridView1.Rows[i].Cells["col_item_id"].Value = item_id.ToString();
if (dt1.Rows[0]["discount"].ToString() == null || dt1.Rows[0]["discount"] == DBNull.Value)
{
dataGridView1.Rows[i].Cells["col_discount"].Value = 0.00;
}
else
{
discount = Convert.ToDecimal(dt1.Rows[0]["discount"].ToString());
dataGridView1.Rows[i].Cells["col_discount"].Value = discount.ToString();
}
//if ((dt1.Rows[0]["discount"].ToString()) == null)
//{
// dataGridView1.Rows[i].Cells["col_discount"].Value = 0.00;
//}
//else
//{
// dataGridView1.Rows[i].Cells["col_discount"].Value = Convert.ToDecimal(dt1.Rows[0]["discount"].ToString());
//}
DataTable dt2 = blli.GetItemCost(item_id);
if (dt2.Rows.Count > 0)
{
dataGridView1.Rows[i].Cells["col_estimate"].Value = Convert.ToDecimal(datagridview_quantity[i]) * Convert.ToDecimal(dt2.Rows[0]["total_cost"].ToString());
}
}
dataGridView1.Rows[i].Cells["cal_cost"].Value = datagridview_item_price[i];
dataGridView1.Rows[i].Cells["cal_total"].Value = datagridview_total[i];
}
calculate_total();
}
hotDiscount();
}