private void ProductGridComboBind(string PLID)
{
try
{
DataTable tbl = new DataTable();
this.clsPOS = new clsPOS();
tbl = this.clsPOS.CallProduct(PLID);
//DataGridViewComboBoxCell colProduct = (DataGridViewComboBoxCell)(dgvSalesInfo.Rows[index].Cells["PName"]);
cboProductName.DataSource = tbl;
cboProductName.DisplayMember = "PName";
cboProductName.ValueMember = "PID";
}
catch (Exception e)
{
MessageBox.Show(e.Message.ToString());
}
}
private void ProductLineGridComboBind()
{
try
{
DataTable tbl = new DataTable();
this.clsPOS = new clsPOS();
tbl = this.clsPOS.CallProductLine();
//DataGridViewComboBoxColumn colProductLine = (DataGridViewComboBoxColumn)(dgvSalesInfo.Columns["PLName"]);
cboProductLineName.DataSource = tbl;
cboProductLineName.DisplayMember = "PLName";
cboProductLineName.ValueMember = "PLID";
cboProductLineName.SelectedIndex = -1;
}
catch (Exception e)
{
MessageBox.Show(e.Message.ToString());
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string tableID = cboTableNo.SelectedValue.ToString();
clsPOS = new clsPOS();
int salesID;
if (this.frmMode == FormMode.New)
{
salesID = clsPOS.AutoID_Sales();
}
else
{
salesID = int.Parse(this.txtSalesID.Text.ToString());
}
clsPOS.SalesID = salesID;
clsPOS.TID = tableID;
clsPOS.SalesDate = DateTime.Now;
clsPOS.SalesDesc = "-";
clsPOS.CID = "-";
clsPOS.CreatedEID = this.EID;
if (this.frmMode == FormMode.New)
{
clsPOS.Ins_Sales();
}
foreach (DataGridViewRow item in dgvSalesInfo.Rows)
{
string productID = item.Cells["colProductID"].Value.ToString();
string quantity = item.Cells["colQuantity"].Value.ToString();
clsPOS = new clsPOS()
{
SalesID = salesID,
TID = tableID,
SalesQty = int.Parse(quantity),
SPID = int.Parse(productID),
SalesDate = DateTime.Now,
SalesDesc = "-",
CID = "-",
CreatedEID = this.EID,
Status = 0
};
clsPOS.Ins_SalesDetail();
clsPOS.WHID = 1;
clsPOS.SPID = int.Parse(productID);
int?invQty = clsPOS.SEL_PQty();
if (this.frmMode == FormMode.Edit)
{
DataTable tbl = new DataTable();
tbl = this.clsPOS.SEL_GetFQty();
if (tbl.Rows.Count > 0)
{
int fQty = int.Parse(tbl.Rows[0][0].ToString());
clsPOS.SalesQty = fQty;
}
}
if (invQty >= clsPOS.SalesQty)
{
clsPOS.IQty = invQty - clsPOS.SalesQty;
clsPOS.UPD_Inventory();
}
}
MessageBox.Show("Data has been saved successfully!", "EABBS", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.newFormMode();
//Showing Order List Process
}
