/// <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)
{
formMDI.infoError.ErrorString = "CPT 5 : " + ex.Message;
}
}
/// <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);
}
}
/// <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)
{
formMDI.infoError.ErrorString = "PSP2:" + ex.Message;
}
}
/// <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);
}
}
/// <summary>
/// Function to fill the Productgroup combobox
/// </summary>
public void ProductGroupComboFill()
{
try
{
DataTable dtbl = new DataTable();
ProductGroupSP spProductGroup = new ProductGroupSP();
dtbl = spProductGroup.ProductGroupViewAll();
DataRow dr = dtbl.NewRow();
dr["groupName"] = "All";
dr["groupId"] = 0;
dtbl.Rows.InsertAt(dr, 0);
cmbProductGroup.DataSource = dtbl;
cmbProductGroup.DisplayMember = "groupName";
cmbProductGroup.ValueMember = "groupId";
}
catch (Exception ex)
{
MessageBox.Show("SER:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill group combobox
/// </summary>
public void GroupComboFill()
{
try
{
DataTable dtbl = new DataTable();
ProductGroupSP spProductGroup = new ProductGroupSP();
dtbl = spProductGroup.ProductGroupViewAll();
cmbGroup.DataSource = dtbl;
cmbGroup.DisplayMember = "groupName";
cmbGroup.ValueMember = "groupId";
}
catch (Exception ex)
{
MessageBox.Show("PC:59" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <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);
}
}