private void cmbProducts_KeyPress(object sender, KeyPressEventArgs e)
{
if (cmbProducts.SelectedIndex > 0)
{
dt.Rows.Clear();
oServiceDB = new ServiceDB();
DataSet ds = oServiceDB.GetProductRateRange(cbCompany.SelectedValue.ToString(), cbBranch.SelectedValue.ToString(), CommonData.FinancialYear, cmbProducts.SelectedValue.ToString());
oServiceDB = null;
if (ds.Tables[0].Rows.Count > 0)
{
dtFromdate.Value = Convert.ToDateTime(ds.Tables[0].Rows[0]["PRRM_FROM_DATE"]);
dtTodate.Value = Convert.ToDateTime(ds.Tables[0].Rows[0]["PRRM_TO_DATE"]);
foreach (DataRow dr in ds.Tables[0].Rows)
{
dt.Rows.Add(new Object[] { dr["PRRM_FROM_QTY_RANGE"].ToString(), dr["PRRM_TO_QTY_RANGE"].ToString(), dr["PRRM_RATE"].ToString(), dr["PRRM_PRODUCT_POINTS"].ToString() });
}
lblCheckID.Text = ds.Tables[0].Rows[0]["PRRM_VALID_TABLE_NUMBER"].ToString();
if (ds.Tables[0].Rows[0]["PRRM_VALID_STATUS"].ToString() == "RUNNING")
{
chkActive.Checked = true;
}
else
{
chkActive.Checked = false;
}
btnDelete.Enabled = true;
}
else
{
btnDelete.Enabled = false;
lblCheckID.Text = "0";
dt.Rows.Add(new Object[] { 1, "", "", "" });
GetGridBind(dt);
}
GetGridBind(dt);
}
else
{
dt.Rows.Clear();
GetGridBind(dt);
}
}
