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));
}
