private DataTable SearchCases()
{
System.Data.DataTable dtResult = new System.Data.DataTable();
dtResult = Database.SearchCases(ui_txtSubmissionFromDate.Text, ui_txtSubmissionToDate.Text, ui_txtTradeName.Text
, int.Parse(ui_drpCompanies.SelectedValue), int.Parse(ui_drpCommitteType.SelectedValue), ui_txtFileNo.Text, int.Parse(ui_drpFileType.SelectedValue), int.Parse(ui_drpStatus.SelectedValue)
, ui_txtGeneric1.Text, ui_txtGeneric2.Text, ui_txtGeneric3.Text, ui_txtGeneric4.Text, ui_txtGeneric5.Text, ui_drpAssignedUser.SelectedValue);
ui_gvSearchResults.DataSource = dtResult;
ui_gvSearchResults.DataBind();
DataTable dt_Result = dtResult;
DataTable dt_Generic;
string Generics;
DataColumn dc = new DataColumn("Generics");
dt_Result.Columns.Add(dc);
foreach (DataRow dr in dt_Result.Rows)
{
v_GetAllGenericInfoByDrugID objData = new Pricing.BLL.v_GetAllGenericInfoByDrugID();
Generics = "";
objData.GetGenericsInfo(int.Parse(dr["TradePricingID"].ToString()));
dt_Generic = objData.DefaultView.Table;
foreach (DataRow drGeneric in dt_Generic.Rows)
{
Generics += @" "" " + drGeneric["Active"] + @" "" ";
}
dr["Generics"] = Generics;
}
ui_gv_Export.DataSource = dt_Result;
ui_gv_Export.DataBind();
return dt_Result;
}
private void LoadGeneric()
{
v_GetAllGenericInfoByDrugID objData = new Pricing.BLL.v_GetAllGenericInfoByDrugID();
objData.GetGenericsInfo(TradePriceID);
GridView_Generic.DataSource = objData.DefaultView;
GridView_Generic.DataBind();
}