//------------------------------------------------------------------------------
// The contents of this file are subject to the nopCommerce Public License Version 1.0 ("License"); you may not use this file except in compliance with the License.
// You may obtain a copy of the License at http://www.nopCommerce.com/License.aspx.
//
// Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied.
// See the License for the specific language governing rights and limitations under the License.
//
// The Original Code is nopCommerce.
// The Initial Developer of the Original Code is NopSolutions.
// All Rights Reserved.
//
// Contributor(s): _______.
//------------------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using Microsoft.Practices.EnterpriseLibrary.Data.Oracle;
using System.Web.Configuration;
using System.Configuration;
using System.Data.SqlClient;
namespace NopSolutions.NopCommerce.DataAccess{
/// <summary>
/// Data helper class
/// </summary>
public partial class NopSqlDataHelper
{
#region Methods
internal static string GetConnectionString(string ConnectionStringName)
{
string connectionString = null;
ConnectionStringSettings settings = WebConfigurationManager.ConnectionStrings[ConnectionStringName];
if (settings != null)
{
connectionString = settings.ConnectionString;
}
return connectionString;
}
/// <summary>
/// Gets connection string to master database
/// </summary>
/// <param name="connetionString">A connection string</param>
/// <returns></returns>
public static string GetMasterConnectionString(string connetionString)
{
var builder = new SqlConnectionStringBuilder(connetionString);
builder.InitialCatalog = "master";
return builder.ToString();
}
/// <summary>
/// Gets database name from connection string
/// </summary>
/// <param name="connetionString">A connection string</param>
/// <returns></returns>
public static string GetDatabaseName(string connetionString)
{
var builder = new SqlConnectionStringBuilder(connetionString);
return builder.InitialCatalog;
}
/// <summary>
/// Creates a connection to a data soruce
/// </summary>
/// <param name="connectionString">Connection string</param>
/// <returns>Database instance</returns>
public static Database CreateConnection(string connectionString)
{
SqlDatabase db = new SqlDatabase(connectionString);
return db;
}
/// <summary>
/// Gets a boolean value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A boolean value</returns>
public static bool GetBoolean(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return false;
}
return Convert.ToBoolean(rdr[index]);
}
/// <summary>
/// Gets a byte array of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A byte array</returns>
public static byte[] GetBytes(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return null;
}
return (byte[])rdr[index];
}
/// <summary>
/// Gets a datetime value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A date time</returns>
[Obsolete("This method will be removed from future Versions. Use GetUtcDateTime", true)]
public static DateTime GetDateTime(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return DateTime.MinValue;
}
return (DateTime)rdr[index];
}
/// <summary>
/// Gets an UTC datetime value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A date time</returns>
public static DateTime GetUtcDateTime(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return DateTime.MinValue;
}
return DateTime.SpecifyKind((DateTime)rdr[index], DateTimeKind.Utc);
}
/// <summary>
/// Gets a nullable datetime value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A date time if exists; otherwise, null</returns>
[Obsolete("This method will be removed from future Versions. Use GetUtcDateTime", true)]
public static DateTime? GetNullableDateTime(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return null;
}
return (DateTime)rdr[index];
}
/// <summary>
/// Gets a nullable UTC datetime value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A date time if exists; otherwise, null</returns>
public static DateTime? GetNullableUtcDateTime(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return null;
}
return DateTime.SpecifyKind((DateTime)rdr[index], DateTimeKind.Utc);
}
/// <summary>
/// Gets a decimal value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A decimal value</returns>
public static decimal GetDecimal(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return decimal.Zero;
}
return Convert.ToDecimal(rdr[index]);
}
/// <summary>
/// Gets a double value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A double value</returns>
public static double GetDouble(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return 0.0;
}
return (double)rdr[index];
}
/// <summary>
/// Gets a GUID value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A GUID value</returns>
public static Guid GetGuid(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return Guid.Empty;
}
return (Guid)rdr[index];
}
/// <summary>
/// Gets an integer value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>An integer value</returns>
public static int GetInt(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return 0;
}
return (int)rdr[index];
}
/// <summary>
/// Gets a nullable integer value of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A nullable integer value</returns>
public static int? GetNullableInt(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return null;
}
return (int)rdr[index];
}
/// <summary>
/// Gets a string of a data reader by a column name
/// </summary>
/// <param name="rdr">Data reader</param>
/// <param name="columnName">Column name</param>
/// <returns>A string value</returns>
public static string GetString(IDataReader rdr, string columnName)
{
int index = rdr.GetOrdinal(columnName);
if (rdr.IsDBNull(index))
{
return string.Empty;
}
return (string)rdr[index];
}
#endregion
}
}
|