/// <summary>
/// unction to get all the values from ServiceCategory Table
/// </summary>
/// <returns></returns>
public List <DataTable> ServiceCategoryViewAll()
{
List <DataTable> ListObj = new List <DataTable>();
try
{
ListObj = spServiceCatogory.ServiceCategoryViewAll();
}
catch (Exception ex)
{
MessageBox.Show("SC8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(ListObj);
}
/// <summary>
/// Category ComboFill Function
/// </summary>
public void CategoryComboFill()
{
try
{
ServiceCategorySP spServiceCatogery = new ServiceCategorySP();
DataTable dtblServiceCatogery = new DataTable();
dtblServiceCatogery = spServiceCatogery.ServiceCategoryViewAll();
cmbCategory.DataSource = dtblServiceCatogery;
cmbCategory.ValueMember = "serviceCategoryId";
cmbCategory.DisplayMember = "categoryName";
}
catch (Exception ex)
{
MessageBox.Show("Ser1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Category Search combo fill
/// </summary>
public void CategorySearchFill()
{
try
{
ServiceCategorySP spServiceCatogery = new ServiceCategorySP();
DataTable dtblServiceCatogery = new DataTable();
dtblServiceCatogery = spServiceCatogery.ServiceCategoryViewAll();
DataRow dr = dtblServiceCatogery.NewRow();
dr[1] = "All";
dtblServiceCatogery.Rows.InsertAt(dr, 0);
cmbCategorySearch.DataSource = dtblServiceCatogery;
cmbCategorySearch.ValueMember = "serviceCategoryId";
cmbCategorySearch.DisplayMember = "categoryName";
}
catch (Exception ex)
{
MessageBox.Show("Ser3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
