private void button1_Click(object sender, EventArgs e)
{
try
{
DialogResult dl = MessageBox.Show("Do you Want to Save Sell Products", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dl == DialogResult.Yes)
{
if (rdb_SaleRoom.Checked == true)
{
cntrl_sell.save_sellProduct(txtBillno.Text.Trim(), txtDate.Text.Trim(), cbRoom.SelectedValue.ToString().Trim(), LoginController.userlogined.Rows[0]["EmpID"].ToString());
for (int list_pro = 0; list_pro < dgvProductsList.Rows.Count; list_pro++)
{
string id = dgvProductsList.Rows[list_pro].Cells[1].Value.ToString().Trim();
double price = double.Parse(dgvProductsList.Rows[list_pro].Cells[4].Value.ToString().Trim());
int Pqty = int.Parse(dgvProductsList.Rows[list_pro].Cells[5].Value.ToString().Trim());
double Total = double.Parse(dgvProductsList.Rows[list_pro].Cells[7].Value.ToString().Trim());
cntrl_sell.save_sellProduct_Detail(id.ToString().Trim(), price.ToString().Trim(), Pqty.ToString().Trim(), Total.ToString().Trim(), txtBillno.Text.Trim());
}
for (int p = 0; p < dgvProductsList.Rows.Count; p++)
{
string id = dgvProductsList.Rows[p].Cells[1].Value.ToString().Trim();
int P_qty = int.Parse(dgvProductsList.Rows[p].Cells[5].Value.ToString().Trim());
int Sum = 0;
cn.da = new System.Data.SqlClient.SqlDataAdapter("Select Qty From Product Where ProductID='" + id + "'", cn.cn);
cn.ds = new DataSet();
cn.da.Fill(cn.ds);
Qty = Convert.ToInt32(cn.ds.Tables[0].Rows[0]["Qty"].ToString());
Sum = Qty - P_qty;
cntrl_sell.Update_instock(Sum.ToString().Trim(), id.Trim());
}
ms.INSERT_Or_SAVE_Successfull();
DialogResult getb = MessageBox.Show("ທ່ານຕ້ອງການພີມໃບບິນຂາຍບໍ", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (getb == DialogResult.Yes)
{
SengkeoHotel.contrl_Sell.billno.frmSellBill f = new billno.frmSellBill(txtBillno.Text);
f.ShowDialog();
txtBillno.Text = cntrl_sell.SellBill().ToString();
dgvProductsList.Rows.Clear();
dgvProStock.DataSource = new DataTable();
cbProductType.Text = "";
cbRoom.Text = "";
rdbSaleOther.Checked = false;
rdb_SaleRoom.Checked = false;
rdb_SaleRoom.Enabled = true;
rdbSaleOther.Enabled = true;
}
else
{
txtBillno.Text = cntrl_sell.SellBill().ToString();
dgvProductsList.Rows.Clear();
dgvProStock.DataSource = new DataTable();
cbProductType.Text = "";
cbRoom.Text = "";
rdbSaleOther.Checked = false;
rdb_SaleRoom.Checked = false;
rdb_SaleRoom.Enabled = true;
rdbSaleOther.Enabled = true;
return;
}
}
if (rdbSaleOther.Checked == true)
{
cntrl_sell.save_SellProductNoRoom(txtBillno.Text.Trim(), txtDate.Text.Trim(), LoginController.userlogined.Rows[0]["EmpID"].ToString());
for (int list_pro = 0; list_pro < dgvProductsList.Rows.Count; list_pro++)
{
string id = dgvProductsList.Rows[list_pro].Cells[1].Value.ToString().Trim();
double price = double.Parse(dgvProductsList.Rows[list_pro].Cells[4].Value.ToString().Trim());
int Pqty = int.Parse(dgvProductsList.Rows[list_pro].Cells[5].Value.ToString().Trim());
double Total = double.Parse(dgvProductsList.Rows[list_pro].Cells[7].Value.ToString().Trim());
cntrl_sell.save_sellProduct_Detail(id.ToString().Trim(), price.ToString().Trim(), Pqty.ToString().Trim(), Total.ToString().Trim(), txtBillno.Text.Trim());
}
for (int p = 0; p < dgvProductsList.Rows.Count; p++)
{
string id = dgvProductsList.Rows[p].Cells[1].Value.ToString().Trim();
int P_qty = int.Parse(dgvProductsList.Rows[p].Cells[5].Value.ToString().Trim());
int Sum = 0;
cn.da = new System.Data.SqlClient.SqlDataAdapter("Select Qty From Product Where ProductID='" + id + "'", cn.cn);
cn.ds = new DataSet();
cn.da.Fill(cn.ds);
Qty = Convert.ToInt32(cn.ds.Tables[0].Rows[0]["Qty"].ToString());
Sum = Qty - P_qty;
cntrl_sell.Update_instock(Sum.ToString().Trim(), id.Trim());
}
ms.INSERT_Or_SAVE_Successfull();
DialogResult getb = MessageBox.Show("ທ່ານຕ້ອງການພີມໃບບິນຂາຍບໍ", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (getb == DialogResult.Yes)
{
SengkeoHotel.contrl_Sell.billno.frmSellBill f = new billno.frmSellBill(txtBillno.Text);
f.ShowDialog();
txtBillno.Text = cntrl_sell.SellBill().ToString();
dgvProductsList.Rows.Clear();
dgvProStock.DataSource = new DataTable();
cbProductType.Text = "";
cbRoom.Text = "";
rdbSaleOther.Checked = false;
rdb_SaleRoom.Checked = false;
rdb_SaleRoom.Enabled = true;
rdbSaleOther.Enabled = true;
}
else
{
txtBillno.Text = cntrl_sell.SellBill().ToString();
dgvProductsList.Rows.Clear();
dgvProStock.DataSource = new DataTable();
cbProductType.Text = "";
cbRoom.Text = "";
rdbSaleOther.Checked = false;
rdb_SaleRoom.Checked = false;
rdb_SaleRoom.Enabled = true;
rdbSaleOther.Enabled = true;
return;
}
}
}
else
{
return;
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}