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