//------------------------------------------------------------------ #endregion #region --------------Update-------------- /// <summary> /// Converts the Cities object properties to SQL paramters and executes the update Cities procedure. /// <example>[Example]bool status=CitiesSqlDataPrvider.Instance.Update(cities);.</example> /// </summary> /// <param name="cities">The Cities object.</param> /// <returns>The status of update query.</returns> public bool Update(CitiesEntity cities) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("Cities_Update", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@CityID", SqlDbType.Int, 4).Value = cities.CityID; myCommand.Parameters.Add("@CountryID", SqlDbType.Int, 4).Value = cities.CountryID; myCommand.Parameters.Add("@NameAr", SqlDbType.NVarChar, 32).Value = cities.NameAr; myCommand.Parameters.Add("@NameEn", SqlDbType.VarChar, 32).Value = cities.NameEn; myCommand.Parameters.Add("@GoogleMapHorizontal", SqlDbType.VarChar, 64).Value = cities.GoogleMapHorizontal; myCommand.Parameters.Add("@GoogleMapVertical", SqlDbType.VarChar, 64).Value = cities.GoogleMapVertical; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command bool status = false; myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { status = true; } myConnection.Close(); return(status); } }
public static CitiesEntity GetObject(int cityID) { CitiesEntity cities = CitiesSqlDataPrvider.Instance.GetObject(cityID); //return the object return(cities); }
public CitiesEntity GetObject(int cityID) { CitiesEntity cities = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("Cities_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@CityID", SqlDbType.Int, 4).Value = cityID; //---------------------------------------------------------------------------------------------- //OwnerID myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = SitesHandler.GetOwnerIDAsGuid(); //---------------------------------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { cities = PopulateCitiesEntityFromIDataReader(dr); } dr.Close(); } myConnection.Close(); return(cities); } }
//---------------------------------------------------------- #endregion #region ----------------BuildCitiesLinks--------------- //---------------------------------------------------------- //BuildCitiesLinks //---------------------------------------------------------- public void BuildCitiesLinks() { CitiesEntity cities = new CitiesEntity(); string NameAr = "مدينة "; string NameEn = "City "; cities.CountryID = SiteSettings.Admininstration_SiteDefaultCountryID; cities.GoogleMapHorizontal = GoogleLatitude; cities.GoogleMapVertical = GoogleLongitude; for (int i = 1; i <= 2; i++) { cities.NameAr = NameAr + i.ToString(); cities.NameEn = NameEn + i.ToString(); CitiesFactory.Create(cities); } }
//------------------------------------------ #endregion #region --------------PopulateCitiesEntityFromIDataReader-------------- private CitiesEntity PopulateCitiesEntityFromIDataReader(IDataReader reader) { //Create a new Cities object CitiesEntity cities = new CitiesEntity(); //Fill the object with data //CityID if (reader["CityID"] != DBNull.Value) { cities.CityID = (int)reader["CityID"]; } //CountryID if (reader["CountryID"] != DBNull.Value) { cities.CountryID = (int)reader["CountryID"]; } //NameAr if (reader["NameAr"] != DBNull.Value) { cities.NameAr = (string)reader["NameAr"]; } //NameEn if (reader["NameEn"] != DBNull.Value) { cities.NameEn = (string)reader["NameEn"]; } //GoogleMapHorizontal if (reader["GoogleMapHorizontal"] != DBNull.Value) { cities.GoogleMapHorizontal = (double)reader["GoogleMapHorizontal"]; } //GoogleMapVertical if (reader["GoogleMapVertical"] != DBNull.Value) { cities.GoogleMapVertical = (double)reader["GoogleMapVertical"]; } //Details ------------------------------------------------------- //Return the populated object return(cities); }
//------------------------------------------ #endregion #region --------------Update-------------- /// <summary> /// Updates Cities object by calling Cities data provider update method. /// <example>[Example]bool status=CitiesFactory.Update(cities);.</example> /// </summary> /// <param name="cities">The Cities object.</param> /// <returns>Status of update operation.</returns> public static bool Update(CitiesEntity cities) { bool status = CitiesSqlDataPrvider.Instance.Update(cities); return(status); }
public static bool Create2(CitiesEntity cities) { return(CitiesSqlDataPrvider.Instance.Create2(cities)); }
//------------------------------------------------------------------ public bool Create2(CitiesEntity cities) { bool result = Createko(typeof(CitiesEntity), cities, "Cities"); return(result); }