/// <summary>
/// Function to Fill product group or tax according to search by combo box selection in Product Group/Tax combo box
/// </summary>
public void ProductGroupTaxComboFill()
{
try
{
if (cmbSearchBy.SelectedIndex == 0)
{
ProductGroupSP spProductGroup = new ProductGroupSP();
DataTable dtblProductGroup = new DataTable();
dtblProductGroup = spProductGroup.ProductGroupViewAll();
cmbProductGroupTax.DataSource = dtblProductGroup;
cmbProductGroupTax.ValueMember = "groupId";
cmbProductGroupTax.DisplayMember = "groupName";
}
else
{
TaxSP spTax = new TaxSP();
DataTable dtblTax = new DataTable();
dtblTax = spTax.TaxViewAll();
cmbProductGroupTax.DataSource = dtblTax;
cmbProductGroupTax.ValueMember = "taxId";
cmbProductGroupTax.DisplayMember = "taxName";
}
}
catch (Exception ex)
{
MessageBox.Show("CPT 5 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public List <DataTable> ProductGroupViewAll()
{
List <DataTable> listObj = new List <DataTable>();
try
{
listObj = spProductGroup.ProductGroupViewAll();
}
catch (Exception ex)
{
MessageBox.Show("AL23:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(listObj);
}
/// <summary>
/// Function to fill the ProductGroup combobox
/// </summary>
public void ProductGroupComboFill()
{
try
{
ProductGroupSP spProductGroup = new ProductGroupSP();
DataTable dtblProductGroup = new DataTable();
dtblProductGroup = spProductGroup.ProductGroupViewAll();
DataRow dr = dtblProductGroup.NewRow();
dr[2] = "All";
dtblProductGroup.Rows.InsertAt(dr, 0);
cmbProductGroup.DataSource = dtblProductGroup;
cmbProductGroup.ValueMember = "groupId";
cmbProductGroup.DisplayMember = "groupName";
}
catch (Exception ex)
{
MessageBox.Show("PSP2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}