//------------------------------------------ #endregion #region --------------GetObject-------------- public static SystemCountriesEntity GetObject(int id) { SystemCountriesEntity systemCountriesObject = SystemCountriesSqlDataPrvider.Instance.GetObject(id); //return the object return(systemCountriesObject); }
//------------------------------------------ #endregion #region --------------PopulateSystemCountriesEntityFromIDataReader-------------- private SystemCountriesEntity PopulateSystemCountriesEntityFromIDataReader(IDataReader reader) { //Create a new SystemCountries object SystemCountriesEntity systemCountriesObject = new SystemCountriesEntity(); //Fill the object with data //id if (reader["id"] != DBNull.Value) { systemCountriesObject.id = (int)reader["id"]; } //country_code if (reader["country_code"] != DBNull.Value) { systemCountriesObject.country_code = (string)reader["country_code"]; } //country if (reader["country"] != DBNull.Value) { systemCountriesObject.country = (string)reader["country"]; } //country_ar if (reader["country_ar"] != DBNull.Value) { systemCountriesObject.country_ar = (string)reader["country_ar"]; } //TIMEZONE_H if (reader["TIMEZONE_H"] != DBNull.Value) { systemCountriesObject.TIMEZONE_H = (int)reader["TIMEZONE_H"]; } //TIMEZONE_M if (reader["TIMEZONE_M"] != DBNull.Value) { systemCountriesObject.TIMEZONE_M = (int)reader["TIMEZONE_M"]; } //reg_id if (reader["reg_id"] != DBNull.Value) { systemCountriesObject.reg_id = (int)reader["reg_id"]; } //SimpleEnName if (reader["SimpleEnName"] != DBNull.Value) { systemCountriesObject.SimpleEnName = (string)reader["SimpleEnName"]; } //SimpleArName if (reader["SimpleArName"] != DBNull.Value) { systemCountriesObject.SimpleArName = (string)reader["SimpleArName"]; } //Return the populated object return(systemCountriesObject); }
//------------------------------------------ #endregion public static string GetCountryFlag(object countryID) { string directoryPath = "/Content/images/flags/"; SystemCountriesEntity cntry = GetObject((int)countryID); if (cntry != null) { return(directoryPath + cntry.country_code + ".png"); } else { return("/Content/images/flags/spacer.gif"); } }
//------------------------------------------ #endregion #region --------------Update-------------- /// <summary> /// Converts the SystemCountries object properties to SQL paramters and executes the update SystemCountries procedure. /// <example>[Example]bool status=SystemCountriesSqlDataPrvider.Instance.Update(systemCountriesObject);.</example> /// </summary> /// <param name="systemCountriesObject">The SystemCountries object.</param> /// <returns>The status of update query.</returns> public bool Update(SystemCountriesEntity systemCountriesObject) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SystemCountries_Update", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@id", SqlDbType.Int, 4).Value = systemCountriesObject.id; myCommand.Parameters.Add("@country", SqlDbType.NVarChar, 255).Value = systemCountriesObject.country; // Execute the command bool status = false; myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { status = true; } myConnection.Close(); return(status); } }
//------------------------------------------ #endregion #region --------------Create-------------- /// <summary> /// Converts the SystemCountries object properties to SQL paramters and executes the create SystemCountries procedure /// and updates the SystemCountries object with the SQL data by reference. /// <example>[Example]bool status=SystemCountriesSqlDataPrvider.Instance.Create(systemCountriesObject);.</example> /// </summary> /// <param name="systemCountriesObject">The SystemCountries object.</param> /// <returns>The status of create query.</returns> public bool Create(SystemCountriesEntity systemCountriesObject) { using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SystemCountries_Create", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@id", SqlDbType.Int, 4).Direction = ParameterDirection.Output; myCommand.Parameters.Add("@country", SqlDbType.NVarChar, 255).Value = systemCountriesObject.country; // Execute the command bool status = false; myConnection.Open(); if (myCommand.ExecuteNonQuery() > 0) { status = true; //Get ID value from database and set it in object systemCountriesObject.id = (int)myCommand.Parameters["@id"].Value; } myConnection.Close(); return(status); } }
public SystemCountriesEntity GetObject(int id) { SystemCountriesEntity systemCountriesObject = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("SystemCountries_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@id", SqlDbType.Int, 4).Value = id; // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { systemCountriesObject = PopulateSystemCountriesEntityFromIDataReader(dr); } dr.Close(); } myConnection.Close(); return(systemCountriesObject); } }
//------------------------------------------ #endregion #region --------------Update-------------- /// <summary> /// Updates SystemCountries object by calling SystemCountries data provider update method. /// <example>[Example]bool status=SystemCountriesFactory.Update(systemCountriesObject);.</example> /// </summary> /// <param name="systemCountriesObject">The SystemCountries object.</param> /// <returns>Status of update operation.</returns> public static bool Update(SystemCountriesEntity systemCountriesObject) { bool status = SystemCountriesSqlDataPrvider.Instance.Update(systemCountriesObject); return(status); }
/// <summary> /// Creates SystemCountries object by calling SystemCountries data provider create method. /// <example>[Example]bool status=SystemCountriesFactory.Create(systemCountriesObject);.</example> /// </summary> /// <param name="systemCountriesObject">The SystemCountries object.</param> /// <returns>Status of create operation.</returns> public static bool Create(SystemCountriesEntity systemCountriesObject) { return(SystemCountriesSqlDataPrvider.Instance.Create(systemCountriesObject)); }