private void BindCompanies()
{
ListItem item = new ListItem(" --- Select All ----", "-1");
// Bind Companies
Companies objCompany = new Companies();
objCompany.LoadAll();
ui_drpCompanies.DataSource = objCompany.DefaultView;
ui_drpCompanies.DataTextField = Companies.ColumnNames.CompNameEng;
ui_drpCompanies.DataValueField = Companies.ColumnNames.CompanyID;
ui_drpCompanies.DataBind();
ui_drpCompanies.Items.Insert(0, item);
ui_ddl_SearchCompany.DataSource = objCompany.DefaultView;
ui_ddl_SearchCompany.DataTextField = Companies.ColumnNames.CompNameEng;
ui_ddl_SearchCompany.DataValueField = Companies.ColumnNames.CompanyID;
ui_ddl_SearchCompany.DataBind();
ui_ddl_SearchCompany.Items.Insert(0, item);
}
/// <summary>
/// Load data for all drop down lists.
/// </summary>
private void BindDropDownListsData()
{
ListItem item = new ListItem(" --- Select ----", "-1");
// Bind Companies
Companies objCompany = new Companies();
objCompany.LoadAll();
ui_drpCompanies.DataSource = objCompany.DefaultView;
ui_drpCompanies.DataTextField = Companies.ColumnNames.CompNameEng;
ui_drpCompanies.DataValueField = Companies.ColumnNames.CompanyID;
ui_drpCompanies.DataBind();
ui_drpCompanies.Items.Insert(0, item);
// Bind Manufactures.
ui_drpManufactures.DataSource = objCompany.DefaultView;
ui_drpManufactures.DataTextField = Companies.ColumnNames.CompNameEng;
ui_drpManufactures.DataValueField = Companies.ColumnNames.CompanyID;
ui_drpManufactures.DataBind();
ui_drpManufactures.Items.Insert(0, item);
// Bind Dosage Forms
Dosage_form objDosageForm = new Dosage_form();
objDosageForm.LoadAll();
ui_drpDosageForm.DataSource = objDosageForm.DefaultView;
ui_drpDosageForm.DataTextField = Dosage_form.ColumnNames.Dosage_form;
ui_drpDosageForm.DataValueField = Dosage_form.ColumnNames.DosageFormID;
ui_drpDosageForm.DataBind();
ui_drpDosageForm.Items.Insert(0, item);
// Bind Registeration_Committee_Type
Registeration_Committee_Type objCommitteType = new Registeration_Committee_Type();
objCommitteType.LoadAll();
ui_drpCommitteType.DataSource = objCommitteType.DefaultView;
ui_drpCommitteType.DataTextField = Registeration_Committee_Type.ColumnNames.CommitteType;
ui_drpCommitteType.DataValueField = Registeration_Committee_Type.ColumnNames.ID;
ui_drpCommitteType.DataBind();
ui_drpCommitteType.Items.Insert(0, item);
// Bind File Types
FileType objFileTypes = new FileType();
objFileTypes.LoadAll();
ui_drpFileType.DataSource = objFileTypes.DefaultView;
ui_drpFileType.DataTextField = FileType.ColumnNames.FileType;
ui_drpFileType.DataValueField = FileType.ColumnNames.FileTypeID;
ui_drpFileType.DataBind();
//ui_drpFileType.Items.Insert(0, item);
}
private void BindAllCompanies()
{
Companies objData = new Companies();
objData.LoadAll();
ui_GvData.DataSource = objData.DefaultView;
ui_GvData.DataBind();
}
/// <summary>
/// Load data for all drop down lists.
/// </summary>
private void BindDropDownListsData()
{
ListItem item = new ListItem(" --- Select ----", "-1");
// Bind Companies
Companies objCompany = new Companies();
objCompany.LoadAll();
ui_drpCompanies.DataSource = objCompany.DefaultView;
ui_drpCompanies.DataTextField = Companies.ColumnNames.CompNameEng;
ui_drpCompanies.DataValueField = Companies.ColumnNames.CompanyID;
ui_drpCompanies.DataBind();
ui_drpCompanies.Items.Insert(0, item);
// Bind Manufactures.
ui_drpManufactures.DataSource = objCompany.DefaultView;
ui_drpManufactures.DataTextField = Companies.ColumnNames.CompNameEng;
ui_drpManufactures.DataValueField = Companies.ColumnNames.CompanyID;
ui_drpManufactures.DataBind();
ui_drpManufactures.Items.Insert(0, item);
// Bind Dosage Forms
Dosage_form objDosageForm = new Dosage_form();
objDosageForm.LoadAll();
ui_drpDosageForm.DataSource = objDosageForm.DefaultView;
ui_drpDosageForm.DataTextField = Dosage_form.ColumnNames.Dosage_form;
ui_drpDosageForm.DataValueField = Dosage_form.ColumnNames.DosageFormID;
ui_drpDosageForm.DataBind();
ui_drpDosageForm.Items.Insert(0, item);
// Bind Registeration_Committee_Type
Registeration_Committee_Type objCommitteType = new Registeration_Committee_Type();
objCommitteType.LoadAll();
ui_drpCommitteType.DataSource = objCommitteType.DefaultView;
ui_drpCommitteType.DataTextField = Registeration_Committee_Type.ColumnNames.CommitteType;
ui_drpCommitteType.DataValueField = Registeration_Committee_Type.ColumnNames.ID;
ui_drpCommitteType.DataBind();
ui_drpCommitteType.Items.Insert(0, item);
uiDropDownListCommitterType_Before.DataSource = objCommitteType.DefaultView;
uiDropDownListCommitterType_Before.DataTextField = Registeration_Committee_Type.ColumnNames.CommitteType;
uiDropDownListCommitterType_Before.DataValueField = Registeration_Committee_Type.ColumnNames.ID;
uiDropDownListCommitterType_Before.DataBind();
uiDropDownListCommitterType_Before.Items.Insert(0, item);
//License Type
TradePricingLicenseType licenseTypes = new TradePricingLicenseType();
licenseTypes.LoadAll();
uiDropDownListLicenseType.DataSource = licenseTypes.DefaultView;
uiDropDownListLicenseType.DataTextField = TradePricingLicenseType.ColumnNames.Name;
uiDropDownListLicenseType.DataValueField = TradePricingLicenseType.ColumnNames.TradePricingLicenseTypeID;
uiDropDownListLicenseType.DataBind();
uiDropDownListLicenseType.Items.Insert(0, item);
//status Type
TradePricingStatus statusTypes = new TradePricingStatus();
statusTypes.LoadAll();
uiDropDownListStatusType.DataSource = statusTypes.DefaultView;
uiDropDownListStatusType.DataTextField = TradePricingStatus.ColumnNames.Name;
uiDropDownListStatusType.DataValueField = TradePricingStatus.ColumnNames.TradePricingStatusID;
uiDropDownListStatusType.DataBind();
uiDropDownListStatusType.Items.Insert(0, item);
//sector Type
SectorType sectorTypes = new SectorType();
sectorTypes.LoadAll();
uiDropDownListSectorType.DataSource = sectorTypes.DefaultView;
uiDropDownListSectorType.DataTextField = SectorType.ColumnNames.Name;
uiDropDownListSectorType.DataValueField = SectorType.ColumnNames.SectorTypeID;
uiDropDownListSectorType.DataBind();
uiDropDownListSectorType.Items.Insert(0, item);
// Bind File Types
FileType objFileTypes = new FileType();
objFileTypes.LoadAll();
ui_drpFileType.DataSource = objFileTypes.DefaultView;
ui_drpFileType.DataTextField = FileType.ColumnNames.FileType;
ui_drpFileType.DataValueField = FileType.ColumnNames.FileTypeID;
ui_drpFileType.DataBind();
//ui_drpFileType.Items.Insert(0, item);
}