public object GetShowcaseDetails(GetShowcaseDetails showcase)
        {
            dynamic ShowcaseDetails;

            try
            {
                var Result = Gallery.GetShowcaseDetails(showcase);

                if (Result != null)
                {
                    ShowcaseDetails = new { status = "0", message = "success", Result };
                }
                else
                {
                    ShowcaseDetails = new { status = "0", message = "Record not found", Result };
                }
            }
            catch
            {
                ShowcaseDetails = new { status = "1", message = "failed" };
            }

            return(new { ShowcaseDetails });
        }
示例#2
0
        public static ClsGetShowcaseDetailsOutPut GetShowcaseDetails(GetShowcaseDetails clschowcase)
        {
            try
            {
                string sqlProc;

                sqlProc = "V1_1_USPGetShowcaseDetails";

                MySqlParameter[] parameterList = new MySqlParameter[1];
                parameterList[0] = new MySqlParameter("?DistrictID", clschowcase.DistrictID);
                //parameterList[1] = new MySqlParameter("?ProfileID", monthCal.profileId);
                //parameterList[2] = new MySqlParameter("?Curr_Date", monthCal.selectedDate);
                //parameterList[3] = new MySqlParameter("?UpdatedOn", monthCal.updatedOn);

                DataSet result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, sqlProc, parameterList);



                ClsGetShowcaseDetailsOutPut showcase = new ClsGetShowcaseDetailsOutPut();
                if (clschowcase.DistrictID == "0")
                {
                    //Inserted One row for ALL as per told rupesh
                    DataTable dt_Category = new DataTable();
                    if (result.Tables[0].Rows.Count > 0)
                    {
                        //DataRow toInsert_Category = result.Tables[0].NewRow();
                        //result.Tables[0].Rows.Add("0", "All", "");
                        DataView dv_Category = result.Tables[0].DefaultView;
                        dv_Category.Sort = "ID ASC";
                        dt_Category      = dv_Category.ToTable();
                        DataRow toInsert_Category1 = dt_Category.NewRow();
                        dt_Category.Rows.Add("-1", "Others", "");
                    }

                    //Inserted One row for ALL as per told rupesh
                    DataTable dt_Club = new DataTable();
                    if (result.Tables[1].Rows.Count > 0)
                    {
                        DataRow toInsert_Club = result.Tables[1].NewRow();
                        result.Tables[1].Rows.Add("0", "All", "");
                        DataView dv_Club = result.Tables[1].DefaultView;
                        dv_Club.Sort = "ID ASC";
                        dt_Club      = dv_Club.ToTable();
                    }

                    //Inserted One row for ALL as per told rupesh
                    DataTable dt_District = new DataTable();
                    if (result.Tables[2].Rows.Count > 0)
                    {
                        DataRow toInsert_District = result.Tables[2].NewRow();
                        result.Tables[2].Rows.Add("0", "All", "");
                        DataView dv_District = result.Tables[2].DefaultView;
                        dv_District.Sort = "ID ASC";
                        dt_District      = dv_District.ToTable();
                    }

                    DataTable dtCategory = dt_Category;
                    DataTable dtClub     = dt_Club;
                    DataTable dtDistrict = dt_District;

                    List <GetShowcaseDetails> CategoryList = new List <GetShowcaseDetails>();
                    if (dtCategory.Rows.Count > 0)
                    {
                        CategoryList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dtCategory);
                    }
                    List <GetShowcaseDetails> ClubList = new List <GetShowcaseDetails>();
                    if (dtClub.Rows.Count > 0)
                    {
                        ClubList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dtClub);
                    }
                    List <GetShowcaseDetails> DistrictList = new List <GetShowcaseDetails>();
                    if (dtDistrict.Rows.Count > 0)
                    {
                        DistrictList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dtDistrict);
                    }

                    showcase.District   = DistrictList;
                    showcase.Club       = ClubList;
                    showcase.Categories = CategoryList;
                }
                else
                {
                    //Inserted One row for ALL as per told rupesh
                    DataTable dt_Club = new DataTable();
                    if (result.Tables[0].Rows.Count > 0)
                    {
                        DataRow toInsert_Club = result.Tables[0].NewRow();
                        result.Tables[0].Rows.Add("0", "All", "");
                        DataView dv_Club = result.Tables[0].DefaultView;
                        dv_Club.Sort = "ID ASC";
                        dt_Club      = dv_Club.ToTable();
                    }

                    //DataTable dtClub = result.Tables[0];

                    List <GetShowcaseDetails> CategoryList = new List <GetShowcaseDetails>();

                    List <GetShowcaseDetails> ClubList = new List <GetShowcaseDetails>();
                    if (dt_Club.Rows.Count > 0)
                    {
                        ClubList = GlobalFuns.DataTableToList <GetShowcaseDetails>(dt_Club);
                    }

                    List <GetShowcaseDetails> DistrictList = new List <GetShowcaseDetails>();


                    showcase.District   = DistrictList;
                    showcase.Club       = ClubList;
                    showcase.Categories = CategoryList;
                }
                return(showcase);
            }
            catch
            {
                throw;
            }
        }