Exemplo n.º 1
0
        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;
        }
Exemplo n.º 2
0
 private void LoadGeneric()
 {
     v_GetAllGenericInfoByDrugID objData = new Pricing.BLL.v_GetAllGenericInfoByDrugID();
     objData.GetGenericsInfo(TradePriceID);
     GridView_Generic.DataSource = objData.DefaultView;
     GridView_Generic.DataBind();
 }