public int CreateReport(string reportId, string nameEn, string nameAr, string nameFr, string source, string sourceAr, string sourceFr, string publishYear, string themes, string runningVariable, string changingVariable , string yearFrom, string yearTo, HtmlGenericControl mydiv) { SqlConnection con = new SqlConnection(ConnectionString12); SqlCommand cmd1 = new SqlCommand(); string insertsql = string.Empty; if (string.IsNullOrEmpty(reportId)) { insertsql = "insert into Reports (ReportEnName,ReportArName, ReportFrName,Source,SourceAr,SourceFr,PublishYear, ThemeID, RunningVariableID, ChangingVariableID"; } else { insertsql = "update Reports set ReportEnName=@ReportEnName,ReportArName=@ReportArName, ReportFrName=@ReportFrName,Source=@Source,SourceAr=@SourceAr,SourceFr=@SourceFr,PublishYear=@PublishYear, ThemeID=@ThemeID, RunningVariableID=@RunningVariableID, ChangingVariableID=@ChangingVariableID"; } ArabicPrepocessor strp = new ArabicPrepocessor(); cmd1.Parameters.Clear(); cmd1.Parameters.Add("ReportEnName", SqlDbType.NVarChar); cmd1.Parameters["ReportEnName"].Value = strp.StripArabicWords(nameEn); cmd1.Parameters.Add("ReportArName", SqlDbType.NVarChar); cmd1.Parameters["ReportArName"].Value = strp.StripArabicWords(nameAr); cmd1.Parameters.Add("ReportFrName", SqlDbType.NVarChar); cmd1.Parameters["ReportFrName"].Value = strp.StripArabicWords(nameFr); cmd1.Parameters.Add("Source", SqlDbType.NVarChar); cmd1.Parameters["Source"].Value = strp.StripArabicWords(source); cmd1.Parameters.Add("SourceAr", SqlDbType.NVarChar); cmd1.Parameters["SourceAr"].Value = strp.StripArabicWords(sourceAr); cmd1.Parameters.Add("SourceFr", SqlDbType.NVarChar); cmd1.Parameters["SourceFr"].Value = strp.StripArabicWords(sourceFr); cmd1.Parameters.Add("PublishYear", SqlDbType.Int); if (String.IsNullOrEmpty(publishYear)) { cmd1.Parameters["PublishYear"].Value = DBNull.Value; } else { cmd1.Parameters["PublishYear"].Value = publishYear; } cmd1.Parameters.Add("ThemeID", SqlDbType.NVarChar); cmd1.Parameters["ThemeID"].Value = themes; cmd1.Parameters.Add("RunningVariableID", SqlDbType.NVarChar); if (runningVariable == "selected") { cmd1.Parameters["RunningVariableID"].Value = DBNull.Value; } else { cmd1.Parameters["RunningVariableID"].Value = runningVariable; } cmd1.Parameters.Add("ChangingVariableID", SqlDbType.NVarChar); cmd1.Parameters["ChangingVariableID"].Value = changingVariable; if (runningVariable == "004" || changingVariable == "004") { if (string.IsNullOrEmpty(reportId)) { insertsql += ",YearID,YearTo"; } else { insertsql += ",YearID=@YearID,YearTo=@YearTo"; } cmd1.Parameters.Add("YearTo", SqlDbType.NVarChar); cmd1.Parameters.Add("YearID", SqlDbType.NVarChar); cmd1.Parameters["YearID"].Value = yearFrom; cmd1.Parameters["YearTo"].Value = yearTo; } for (int y = 0; y < i; y++) { RadioButtonList VariablesRadio = (RadioButtonList)(mydiv.FindControl("VariablesRadio" + y)); RadioButtonList VariableValuehck = (RadioButtonList)(mydiv.FindControl("VariablesValueChck" + y)); //if (VariableValuehck.SelectedIndex < 0 || VariablesRadio.SelectedIndex < 0) //{ // VariableValuehck.SelectedIndex = 0; // VariablesRadio.SelectedIndex = 0; //} if (VariablesRadio.SelectedIndex >= 0 && VariableValuehck.SelectedIndex >= 0) { if (VariableValuehck.SelectedValue.Substring(3) != "00001" && VariablesRadio.SelectedValue != "unselect") { if (string.IsNullOrEmpty(reportId)) { insertsql = insertsql + ", " + VariablesRadio.SelectedValue.ToString(); } else { insertsql = insertsql + ", " + VariablesRadio.SelectedValue.ToString() + "='" + VariableValuehck.SelectedValue.ToString() + "'"; } } } } if (string.IsNullOrEmpty(reportId)) { insertsql = insertsql + " ) values (@ReportEnName,@ReportArName, @ReportFrName,@Source,@SourceAr,@SourceFr,@PublishYear, @ThemeID, @RunningVariableID, @ChangingVariableID"; } if (runningVariable == "004" || changingVariable == "004") { if (string.IsNullOrEmpty(reportId)) { insertsql += ",@YearID, @YearTo"; } } for (int y = 0; y < i; y++) { RadioButtonList VariablesRadio = (RadioButtonList)(mydiv.FindControl("VariablesRadio" + y)); RadioButtonList VariableValuehck = (RadioButtonList)(mydiv.FindControl("VariablesValueChck" + y)); if (VariablesRadio.SelectedIndex >= 0 && VariableValuehck.SelectedIndex >= 0) { if (VariableValuehck.SelectedValue.Substring(3) != "00001" && VariablesRadio.SelectedValue != "unselect") { //if (VariableValuehck.SelectedIndex < 0 || VariablesRadio.SelectedIndex < 0) //{ // VariableValuehck.SelectedIndex = 0; // VariablesRadio.SelectedIndex = 0; //} if (VariablesRadio.SelectedIndex >= 0 && VariableValuehck.SelectedIndex >= 0) { if (string.IsNullOrEmpty(reportId)) { insertsql = insertsql + ",'" + VariableValuehck.SelectedValue.ToString() + "'"; } } } } } if (string.IsNullOrEmpty(reportId)) { insertsql = insertsql + " )"; } if (!string.IsNullOrEmpty(reportId)) { string column = "YearID, YearTo, GenderID, GovID, MaritalStatusID,EducationLevelID,AgeID, SectorID, CountryID, MonthID, NationailtyID, SchoolTypeID, " + "EconomicActivityID, CostID, GeographicalDistributionID, GovernoratesGroupID, GenderRatioID, EstablishmentID, AgeID3, UniversityID, FacultyID, " + "InistitueID, DropOutID, TeahcingPositionsID, WaterID, WaterProducerID, RoadID, VehicleID, TransportedItemID, CargoStatusTravelingID, TravelStatusID, " + "CommodityID, CommodityGroupID, CaseTypeID, CaseStatusID, AssociationsActivityID, CulturalServiceAssociationsID, SocialServiceAssociationsID, IssuedCapitalID, " + "WaterPollutionIndicatorID, TransportingFacilityID, PortNameID, AirPollutionID, AreaDateID, CropsSeasonID, liveStockID, OriginPlaceID, BorrowingPurposeID, AuthoritySurveillanceID, " + "ServiceID, FisheryRegionID, FoodProductsID, ChemicalProductID, PaperPrintingProductID, RubberPlasticProductID, TextileProductID, MetalicEngineeringElectricProductID, " + "ConstrcutionsMaterialRefractoryProductID, PetroluemNaturalGasProductID, TradeID, CountriesGroupID, ArrivalMethodID, HotelTypeID, RadioStationID, ProgramTypeID, " + "SubjectTypeID, MuseumTypeID, IndustrySectionsID, EducationalTypeID, ExtraVariableID, ExtraVariableValue"; foreach (string itm in column.Split(new[] { ',' })) { if (!insertsql.Contains(itm.Trim())) { insertsql += " , " + itm + " = null "; } } insertsql += " where ReportID=" + reportId; } cmd1.Connection = con; cmd1.CommandType = CommandType.Text; cmd1.CommandText = insertsql; con.Open(); int result = cmd1.ExecuteNonQuery(); con.Close(); return(result); }
public List <Infrastructure.Data.Entities.ThemeVm> GetAThemesesByName(string name) { name = new ArabicPrepocessor().StripArabicWords(name); return(_repo.GetAThemesesByName(name)); }