public static bool Update(
Guid guid,
int sort)
{
SqlParameter[] arParams = new SqlParameter[2];
if (ConfigurationManager.AppSettings["CacheMSSQLParameters"].ToLower() == "true")
{
arParams = SqlHelperParameterCache.GetParameterSet(GetConnectionString(),
"ws_OrderStatus_Update");
arParams[0].Value = guid;
arParams[1].Value = sort;
}
else
{
arParams[0] = new SqlParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlParameter("@Sort", SqlDbType.Int);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = sort;
}
int rowsAffected = SqlHelper.ExecuteNonQuery(GetConnectionString(),
CommandType.StoredProcedure,
"ws_OrderStatus_Update",
arParams);
return(rowsAffected > -1);
}
public static IDataReader GetDescription(
Guid statusGuid,
Guid languageGuid)
{
SqlParameter[] arParams = new SqlParameter[2];
if (ConfigurationManager.AppSettings["CacheMSSQLParameters"].ToLower() == "true")
{
arParams = SqlHelperParameterCache.GetParameterSet(GetConnectionString(),
"ws_OrderStatusDescription_SelectOne");
arParams[0].Value = statusGuid;
arParams[1].Value = languageGuid;
}
else
{
arParams[0] = new SqlParameter("@StatusGuid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = statusGuid;
arParams[1] = new SqlParameter("@LanguageGuid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = languageGuid;
}
return(SqlHelper.ExecuteReader(
GetConnectionString(),
CommandType.StoredProcedure,
"ws_OrderStatusDescription_SelectOne",
arParams));
}
public static bool Update(
Guid guid,
Guid currencyGuid,
decimal price,
DateTime lastModifed,
Guid lastModifiedBy,
string modifiedFromIP)
{
SqlParameter[] arParams = new SqlParameter[6];
if (ConfigurationManager.AppSettings["CacheMSSQLParameters"].ToLower() == "true")
{
arParams = SqlHelperParameterCache.GetParameterSet(GetConnectionString(),
"ws_OfferPrice_Update");
arParams[0].Value = guid;
arParams[1].Value = currencyGuid;
arParams[2].Value = price;
arParams[3].Value = lastModifed;
arParams[4].Value = lastModifiedBy;
arParams[5].Value = modifiedFromIP;
}
else
{
arParams[0] = new SqlParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlParameter("@CurrencyGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = currencyGuid;
arParams[2] = new SqlParameter("@Price", SqlDbType.Decimal);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = price;
arParams[3] = new SqlParameter("@LastModifed", SqlDbType.DateTime);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = lastModifed;
arParams[4] = new SqlParameter("@LastModifiedBy", SqlDbType.UniqueIdentifier);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = lastModifiedBy;
arParams[5] = new SqlParameter("@ModifiedFromIP", SqlDbType.NVarChar, 255);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = modifiedFromIP;
}
int rowsAffected = SqlHelper.ExecuteNonQuery(GetConnectionString(),
CommandType.StoredProcedure,
"ws_OfferPrice_Update",
arParams);
return(rowsAffected > -1);
}
public static IDataReader GetByOffer(Guid offerGuid)
{
SqlParameter[] arParams = new SqlParameter[1];
if (ConfigurationManager.AppSettings["CacheMSSQLParameters"].ToLower() == "true")
{
arParams = SqlHelperParameterCache.GetParameterSet(GetConnectionString(),
"ws_OfferPrice_SelectByOffer");
arParams[0].Value = offerGuid;
}
else
{
arParams[0] = new SqlParameter("@OfferGuid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = offerGuid;
}
return(SqlHelper.ExecuteReader(
GetConnectionString(),
CommandType.StoredProcedure,
"ws_OfferPrice_SelectByOffer",
arParams));
}
public static bool UpdateDescription(
Guid statusGuid,
Guid languageGuid,
string description)
{
SqlParameter[] arParams = new SqlParameter[3];
if (ConfigurationManager.AppSettings["CacheMSSQLParameters"].ToLower() == "true")
{
arParams = SqlHelperParameterCache.GetParameterSet(GetConnectionString(),
"ws_OrderStatusDescription_Update");
arParams[0].Value = statusGuid;
arParams[1].Value = languageGuid;
arParams[2].Value = description;
}
else
{
arParams[0] = new SqlParameter("@StatusGuid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = statusGuid;
arParams[1] = new SqlParameter("@LanguageGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = languageGuid;
arParams[2] = new SqlParameter("@Description", SqlDbType.NVarChar, 255);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = description;
}
int rowsAffected = SqlHelper.ExecuteNonQuery(GetConnectionString(),
CommandType.StoredProcedure,
"ws_OrderStatusDescription_Update",
arParams);
return(rowsAffected > -1);
}
public static bool DeleteDescription(Guid statusGuid)
{
SqlParameter[] arParams = new SqlParameter[1];
if (ConfigurationManager.AppSettings["CacheMSSQLParameters"].ToLower() == "true")
{
arParams = SqlHelperParameterCache.GetParameterSet(GetConnectionString(),
"ws_OrderStatusDescription_DeleteByStatus");
arParams[0].Value = statusGuid;
}
else
{
arParams[0] = new SqlParameter("@StatusGuid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = statusGuid;
}
int rowsAffected = SqlHelper.ExecuteNonQuery(GetConnectionString(),
CommandType.StoredProcedure,
"ws_OrderStatusDescription_DeleteByStatus",
arParams);
return(rowsAffected > -1);
}
public static int AddHistory(
Guid guid,
Guid priceGuid,
Guid offerGuid,
Guid currencyGuid,
decimal price,
DateTime created,
Guid createdBy,
string createdFromIP,
DateTime lastModifed,
Guid lastModifiedBy,
string modifiedFromIP,
DateTime logTime)
{
SqlParameter[] arParams = new SqlParameter[12];
if (ConfigurationManager.AppSettings["CacheMSSQLParameters"].ToLower() == "true")
{
arParams = SqlHelperParameterCache.GetParameterSet(GetConnectionString(),
"ws_OfferPriceHistory_Insert");
arParams[0].Value = guid;
arParams[1].Value = priceGuid;
arParams[2].Value = offerGuid;
arParams[3].Value = currencyGuid;
arParams[4].Value = price;
arParams[5].Value = created;
arParams[6].Value = createdBy;
arParams[7].Value = createdFromIP;
arParams[8].Value = lastModifed;
arParams[9].Value = lastModifiedBy;
arParams[10].Value = modifiedFromIP;
arParams[11].Value = logTime;
}
else
{
arParams[0] = new SqlParameter("@Guid", SqlDbType.UniqueIdentifier);
arParams[0].Direction = ParameterDirection.Input;
arParams[0].Value = guid;
arParams[1] = new SqlParameter("@PriceGuid", SqlDbType.UniqueIdentifier);
arParams[1].Direction = ParameterDirection.Input;
arParams[1].Value = priceGuid;
arParams[2] = new SqlParameter("@OfferGuid", SqlDbType.UniqueIdentifier);
arParams[2].Direction = ParameterDirection.Input;
arParams[2].Value = offerGuid;
arParams[3] = new SqlParameter("@CurrencyGuid", SqlDbType.UniqueIdentifier);
arParams[3].Direction = ParameterDirection.Input;
arParams[3].Value = currencyGuid;
arParams[4] = new SqlParameter("@Price", SqlDbType.Decimal);
arParams[4].Direction = ParameterDirection.Input;
arParams[4].Value = price;
arParams[5] = new SqlParameter("@Created", SqlDbType.DateTime);
arParams[5].Direction = ParameterDirection.Input;
arParams[5].Value = created;
arParams[6] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
arParams[6].Direction = ParameterDirection.Input;
arParams[6].Value = createdBy;
arParams[7] = new SqlParameter("@CreatedFromIP", SqlDbType.NVarChar, 255);
arParams[7].Direction = ParameterDirection.Input;
arParams[7].Value = createdFromIP;
arParams[8] = new SqlParameter("@LastModifed", SqlDbType.DateTime);
arParams[8].Direction = ParameterDirection.Input;
arParams[8].Value = lastModifed;
arParams[9] = new SqlParameter("@LastModifiedBy", SqlDbType.UniqueIdentifier);
arParams[9].Direction = ParameterDirection.Input;
arParams[9].Value = lastModifiedBy;
arParams[10] = new SqlParameter("@ModifiedFromIP", SqlDbType.NVarChar, 255);
arParams[10].Direction = ParameterDirection.Input;
arParams[10].Value = modifiedFromIP;
arParams[11] = new SqlParameter("@LogTime", SqlDbType.DateTime);
arParams[11].Direction = ParameterDirection.Input;
arParams[11].Value = logTime;
}
int rowsAffected = Convert.ToInt32(SqlHelper.ExecuteNonQuery(GetConnectionString(),
CommandType.StoredProcedure,
"ws_OfferPriceHistory_Insert",
arParams));
return(rowsAffected);
}
