public void Update_Normally_ShouldWork()
{
Category createdCategory, updatedCategory;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new CategoriesController(dataLayer))
{
createdCategory = controller.CreateCategory(TestDataProvider.CreateNewCategory());
controller.Update(new CategoryUpdate {
Id = createdCategory.Id, Name = "Cinema"
});
updatedCategory = controller.Get(createdCategory.Id);
}
Assert.AreEqual("Cinema", updatedCategory.Name);
}
public void Update_Normally_ShouldWork()
{
Currency createdCurrency, updatedCurrency;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new CurrenciesController(dataLayer))
{
createdCurrency = controller.CreateCurrency(TestDataProvider.CreateNewCurrency());
controller.Update(new CurrencyUpdate {
Id = createdCurrency.Id, Code = "USD"
});
updatedCurrency = controller.Get(createdCurrency.Id);
}
Assert.AreEqual("USD", updatedCurrency.Code);
}
public void Get_Normally_ShouldReturn_PartnerWithId()
{
Partner createdPartner, queriedPartner;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new PartnersController(dataLayer))
{
createdPartner = controller.CreatePartner(TestDataProvider.CreateNewPartner());
queriedPartner = controller.Get(createdPartner.Id);
}
Assert.IsTrue(
queriedPartner.IsEqualTo(createdPartner),
"The two partners should be equal. "
+ $"Expected: {createdPartner.Stringify()}, actual: {queriedPartner.Stringify()}.");
}
public void Get_Normally_ShouldReturn_CategoryWithId()
{
Category createdCategory, queriedCategory;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new CategoriesController(dataLayer))
{
createdCategory = controller.CreateCategory(TestDataProvider.CreateNewCategory());
queriedCategory = controller.Get(createdCategory.Id);
}
Assert.IsTrue(
queriedCategory.IsEqualTo(createdCategory),
"The two categories should be equal. "
+ $"Expected: {createdCategory.Stringify()}, actual: {queriedCategory.Stringify()}.");
}
/// <summary>
/// Initializes a new database
/// </summary>
public static void InitializeDatabase()
{
ConfigurationManager.AppSettings.Set(Core.Configuration.GlobalSettings.UmbracoConnectionName, @"datalayer=SQLCE4Umbraco.SqlCEHelper,SQLCE4Umbraco;data source=|DataDirectory|\UmbracoPetaPocoTests.sdf;Flush Interval=1;");
ClearDatabase();
var databaseSettings = ConfigurationManager.ConnectionStrings[Core.Configuration.GlobalSettings.UmbracoConnectionName];
var dataHelper = DataLayerHelper.CreateSqlHelper(databaseSettings.ConnectionString, false);
var installer = dataHelper.Utility.CreateInstaller();
if (installer.CanConnect)
{
installer.Install();
}
}
public ICoupon Get(int discountId, string couponCode)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
using (var reader = sqlHelper.ExecuteReader("SELECT * FROM uWebshopCoupons WHERE DiscountId = @discountId AND CouponCode = @couponCode", sqlHelper.CreateParameter("@discountId", discountId), sqlHelper.CreateParameter("@couponCode", couponCode)))
{
while (reader.Read())
{
var orderInfo = reader.GetString("orderInfo");
if (!string.IsNullOrEmpty(orderInfo))
{
return(new Coupon(reader));
}
}
return(null);
}
}
public void InstallCouponsTable()
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
try
{
sqlHelper.ExecuteNonQuery(@"CREATE TABLE
[uWebshopCoupons](
[DiscountId] [int] NOT NULL,
[CouponCode] nvarchar (500) NOT NULL,
[NumberAvailable] [int] NOT NULL)" );
}
catch (Exception ex)
{
Log.Add(LogTypes.Debug, 0, "InstallCouponsTable Catch: Already Exists?");
}
}
public void Update_Normally_ShouldWork()
{
Partner createdPartner, updatedPartner;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new PartnersController(dataLayer))
{
createdPartner = controller.CreatePartner(TestDataProvider.CreateNewPartner());
controller.Update(new PartnerUpdate {
Id = createdPartner.Id, Name = "Eleanor Rigby", Address = "Liverpool"
});
updatedPartner = controller.Get(createdPartner.Id);
}
Assert.AreEqual("Eleanor Rigby", updatedPartner.Name);
Assert.AreEqual("Liverpool", updatedPartner.Address);
}
public void Delete_Normally_ShouldWork()
{
Partner createdPartner, queriedPartner;
IEnumerable <Partner> listedPartners;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new PartnersController(dataLayer))
{
createdPartner = controller.CreatePartner(TestDataProvider.CreateNewPartner());
queriedPartner = controller.Get(createdPartner.Id);
controller.Delete(createdPartner.Id);
listedPartners = controller.List();
}
Assert.AreEqual(createdPartner.Id, queriedPartner.Id, "Unexpected ID.");
Assert.AreEqual(false, listedPartners.Any(), "There should be no partners returned.");
}
public static OrderData GetOrderInfo(string transactionId)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
using (var reader = sqlHelper.ExecuteReader("SELECT * FROM uWebshopOrders WHERE transactionID = @transactionID", sqlHelper.CreateParameter("@transactionID", transactionId)))
{
while (reader.Read())
{
var orderInfo = reader.GetString("orderInfo");
if (!string.IsNullOrEmpty(orderInfo))
{
return(new OrderData(reader));
}
}
return(null);
}
}
public void Delete_Normally_ShouldWork()
{
Category createdCategory, queriedCategory;
IEnumerable <Category> listedCategories;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new CategoriesController(dataLayer))
{
createdCategory = controller.CreateCategory(TestDataProvider.CreateNewCategory());
queriedCategory = controller.Get(createdCategory.Id);
controller.Delete(createdCategory.Id);
listedCategories = controller.List();
}
Assert.AreEqual(createdCategory.Id, queriedCategory.Id, "Unexpected ID.");
Assert.AreEqual(false, listedCategories.Any(), "There should be no categories returned.");
}
private void InitializeDatabase()
{
ConfigurationManager.AppSettings.Set(Core.Configuration.GlobalSettings.UmbracoConnectionName, @"datalayer=SQLCE4Umbraco.SqlCEHelper,SQLCE4Umbraco;data source=|DataDirectory|\UmbracoPetaPocoTests.sdf");
ClearDatabase();
AppDomain.CurrentDomain.SetData("DataDirectory", TestHelper.CurrentAssemblyDirectory);
var databaseSettings = ConfigurationManager.ConnectionStrings[Core.Configuration.GlobalSettings.UmbracoConnectionName];
var dataHelper = DataLayerHelper.CreateSqlHelper(databaseSettings.ConnectionString, false) as SqlCEHelper;
var installer = dataHelper.Utility.CreateInstaller();
if (installer.CanConnect)
{
installer.Install();
}
}
public void Create_WhenTitleNull_ShouldThrow()
{
var newTransfer = new NewTransfer
{
CategoryId = 1,
PartnerId = 1,
CurrencyId = 1,
Title = null,
Time = DateTime.UtcNow,
Discount = 0.3M,
Note = null,
Items = null,
};
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new TransfersController(dataLayer))
controller.Create(newTransfer);
}
/// <summary>
/// Retrieve HTML from the database cache for the given node
/// </summary>
/// <param name="nodeId">Id of the node</param>
/// <param name="fullHtml">string to fill with HTML</param>
/// <returns>bool indicating success/failure</returns>
public static bool GetRecord(int nodeId, out string fullHtml)
{
fullHtml = "";
if (nodeId < 1)
{
return(false);
}
var success = false;
ISqlHelper sqlHelper = null;
IRecordsReader result = null;
try
{
const string sqlQuery = "SELECT fullHTML FROM fullTextCache WHERE nodeId = @nodeId";
sqlHelper = DataLayerHelper.CreateSqlHelper(global::Umbraco.Core.ApplicationContext.Current.DatabaseContext.ConnectionString);
result = sqlHelper.ExecuteReader(sqlQuery, sqlHelper.CreateParameter("@nodeId", nodeId));
if (result != null && result.HasRecords && result.Read() && result.ContainsField("fullHTML"))
{
fullHtml = result.GetString("fullHTML");
success = true;
}
}
catch (umbraco.UmbracoException ex)
{
LogHelper.Error(typeof(DbAccess), "Error In Database Query to fullTextCache", ex);
fullHtml = "";
}
finally
{
if (result != null)
{
result.Close();
}
if (sqlHelper != null)
{
sqlHelper.Dispose();
}
}
return(success);
}
public static List <OrderData> GetAllOrderInfos(string where = null)
{
if (where == null)
{
where = string.Empty;
}
var orderInfos = new List <OrderData>();
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
//Log.Instance.LogDebug(DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + " >>>>SQL<<<< SELECT orderInfo");
using (var reader = sqlHelper.ExecuteReader("SELECT * FROM uWebshopOrders " + where))
{
while (reader.Read())
{
orderInfos.Add(new OrderData(reader));
}
return(orderInfos);
}
}
public static void SetOrderInfo(Guid orderId, string serializedOrderInfoObject, string orderStatus)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
if (sqlHelper.ConnectionString.Contains("|DataDirectory|") || DataLayerHelper.IsEmbeddedDatabase(GlobalSettings.DbDSN) || GlobalSettings.DbDSN.ToLower().Contains("mysql"))
{
// SQLCE gets a performance hit (extra query, no way around it)
var orderExists = GetOrderInfo(orderId) != null;
//if (orderExists)
// Log.Instance.LogDebug(DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + " >>>>SQL<<<< UPDATE orderInfo");
//else
// Log.Instance.LogDebug(DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + " >>>>SQL<<<< INSERT orderInfo");
sqlHelper.ExecuteNonQuery(orderExists ? @"UPDATE uWebshopOrders set orderInfo = @orderInfo, orderStatus = @orderStatus, updateDate = @updateDate where uniqueID = @uniqueID" : @"INSERT into uWebshopOrders(uniqueID, orderInfo, orderStatus, createDate, updateDate) values(@uniqueID, @orderInfo, @orderStatus, @createDate, @updateDate)", sqlHelper.CreateParameter("@orderInfo", serializedOrderInfoObject), sqlHelper.CreateParameter("@uniqueID", orderId), sqlHelper.CreateParameter("@orderStatus", orderStatus), sqlHelper.CreateParameter("@createDate", DateTime.Now), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
else
{
//Log.Instance.LogDebug(DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + " >>>>SQL<<<< combined INSERTorUPDATE orderInfo");
sqlHelper.ExecuteNonQuery("IF (SELECT Count(ID) FROM uWebshopOrders WHERE uniqueID = @uniqueId)=0 BEGIN insert into uWebshopOrders(uniqueID, orderInfo, orderStatus, createDate, updateDate) " + "values(@uniqueID, @orderInfo, @orderStatus, @createDate, @updateDate) END ELSE BEGIN update uWebshopOrders set orderInfo = @orderInfo, orderStatus = @orderStatus, updateDate = @updateDate where uniqueID = @uniqueID END", sqlHelper.CreateParameter("@orderInfo", serializedOrderInfoObject), sqlHelper.CreateParameter("@uniqueID", orderId), sqlHelper.CreateParameter("@orderStatus", orderStatus), sqlHelper.CreateParameter("@createDate", DateTime.Now), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
}
public static string GetHighestOrderNumber(ref int referenceId)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
using (var reader = sqlHelper.ExecuteReader("SELECT orderNumber, storeOrderReferenceID FROM uWebshopOrders ORDER BY id DESC"))
{
while (reader.Read())
{
referenceId = reader.Get <int>("storeOrderReferenceID");
var orderNumber = reader.Get <string>("orderNumber");
if (!string.IsNullOrEmpty(orderNumber) && !orderNumber.StartsWith("[INCOMPLETE]"))
{
return(orderNumber);
}
}
}
return(null);
}
// public static void InstallOrderNumberTable()
// {
// var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
// sqlHelper.ExecuteNonQuery(
// @"CREATE TABLE
// [uWebshopOrderNumber](
// [id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
// [StoreAlias] nvarchar (500) NULL,
// [Counter] int NULL)");
// }
public static void SetCustomerInfo(Guid orderId, XElement element)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
if (element.Name == "customerEmail")
{
//Log.Instance.LogDebug(DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + " >>>>SQL<<<< UPDATE customerEmail");
sqlHelper.ExecuteNonQuery("update uWebshopOrders set customerEmail = @customerEmail, updateDate = @updateDate where uniqueID = @uniqueID", sqlHelper.CreateParameter("@uniqueID", orderId), sqlHelper.CreateParameter("@customerEmail", element.Value), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
if (element.Name == "customerFirstName")
{
//Log.Instance.LogDebug(DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + " >>>>SQL<<<< UPDATE customerFirstName");
sqlHelper.ExecuteNonQuery("update uWebshopOrders set customerFirstName = @customerFirstName, updateDate = @updateDate where uniqueID = @uniqueID", sqlHelper.CreateParameter("@uniqueID", orderId), sqlHelper.CreateParameter("@customerFirstName", element.Value), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
if (element.Name == "customerLastName")
{
//Log.Instance.LogDebug(DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss.fff tt") + " >>>>SQL<<<< UPDATE customerLastName");
sqlHelper.ExecuteNonQuery("update uWebshopOrders set customerLastName = @customerLastName, updateDate = @updateDate where uniqueID = @uniqueID", sqlHelper.CreateParameter("@uniqueID", orderId), sqlHelper.CreateParameter("@customerLastName", element.Value), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
}
public void Save(int discountId, IEnumerable <ICoupon> coupons)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
sqlHelper.ExecuteNonQuery("delete from [uWebshopCoupons] WHERE DiscountId = @discountId", sqlHelper.CreateParameter("@discountId", discountId));
if (coupons.Any())
{
if (sqlHelper.ConnectionString.Contains("|DataDirectory|") || DataLayerHelper.IsEmbeddedDatabase(GlobalSettings.DbDSN) || GlobalSettings.DbDSN.ToLower().Contains("mysql"))
{
foreach (var coupon in coupons)
{
sqlHelper.ExecuteNonQuery(@"INSERT into uWebshopCoupons(DiscountId, CouponCode, NumberAvailable) values(@discountId, @couponcode, @numberavailable)", sqlHelper.CreateParameter("@discountId", coupon.DiscountId), sqlHelper.CreateParameter("@couponcode", coupon.CouponCode), sqlHelper.CreateParameter("@numberavailable", coupon.NumberAvailable));
}
}
else
{
sqlHelper.ExecuteNonQuery("insert into [uWebshopCoupons] (DiscountId, CouponCode, NumberAvailable) VALUES " + string.Join(", ", coupons.Select(c => "(" + c.DiscountId + ", '" + c.CouponCode + "', " + c.NumberAvailable + ")").ToArray()));
}
}
}
public static int AssignNewOrderNumberToOrderSharedBasket(int databaseId, string alias, int orderNumberStartNumber)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
if (databaseId <= 0)
{
throw new Exception("No valid database id");
}
return(sqlHelper.ExecuteScalar <int>(@"begin tran
declare @storeOrderReferenceID int
set @storeOrderReferenceID = coalesce((SELECT top 1 storeOrderReferenceID FROM uWebshopOrders ORDER BY storeOrderReferenceID DESC),0) + 1
set @storeOrderReferenceID = case when @orderNumberStartNumber > @storeOrderReferenceID then @orderNumberStartNumber else @storeOrderReferenceID end
update uWebshopOrders set storeOrderReferenceID = @storeOrderReferenceID, storeAlias = @storeAlias, updateDate = @updateDate where id = @id
select @storeOrderReferenceID
commit tran", sqlHelper.CreateParameter("@id", databaseId), sqlHelper.CreateParameter("@orderNumberStartNumber", orderNumberStartNumber), sqlHelper.CreateParameter("@storeAlias", alias), sqlHelper.CreateParameter("@updateDate", DateTime.Now)));
}
public static void SetCustomerInfo(Guid orderId, string customerEmail, string customerFirstName, string customerLastName)
{
if (string.IsNullOrEmpty(customerFirstName))
{
customerFirstName = string.Empty;
}
if (string.IsNullOrEmpty(customerLastName))
{
customerLastName = string.Empty;
}
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
sqlHelper.ExecuteNonQuery("update uWebshopOrders set customerEmail = @customerEmail, " +
"customerFirstName = @customerFirstName, customerLastName = @customerLastName, " +
"updateDate = @updateDate where uniqueID = @uniqueID",
sqlHelper.CreateParameter("@uniqueID", orderId),
sqlHelper.CreateParameter("@customerEmail", customerEmail),
sqlHelper.CreateParameter("@customerFirstName", customerFirstName),
sqlHelper.CreateParameter("@customerLastName", customerLastName),
sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
public static void InstallStockTable()
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
try
{
sqlHelper.ExecuteNonQuery(@"CREATE TABLE
[uWebshopStock](
[id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[Stock] [int] NOT NULL,
[NodeId] [int] NULL,
[OrderCount] [int] NOT NULL,
[StoreAlias] nvarchar (500) NULL,
[createDate] [datetime] NULL,
[updateDate] [datetime] NULL)" );
}
catch (Exception ex)
{
//Log.Instance.LogDebug("InstallStockTable Catch: Already Exists?");
Log.Add(LogTypes.Debug, 0, "InstallStockTable Catch: Already Exists?");
}
}
public void Create_Normally_ShouldReturn_Category()
{
var newCategory = TestDataProvider.CreateNewCategory();
CreatedAtActionResult actionResult;
Category category;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var controller = new CategoriesController(dataLayer))
{
actionResult = (CreatedAtActionResult)controller.Create(newCategory);
category = (Category)actionResult.Value;
}
Assert.AreEqual(actionResult.ActionName, "Get");
Assert.IsTrue(
category.Id > 0,
$"Category ID is expected to greater than 0. Actual: {category.Id}.");
Assert.AreEqual(
newCategory.Name,
category.Name,
$"Invalid category name. Expected: \"{newCategory.Name}\", actual: \"{category.Name}\".");
}
public void Run(string configFile, string connectionString)
{
Log.Debug("Running SQL Server install");
var sql = Helper.Instance.ReadAssemblyResource("Resources.Sql.SqlServer.Install.sql");
Log.Debug("Read SQL from resource stream");
Log.Debug(sql);
Log.Debug("Executing SQL");
var helper = DataLayerHelper.CreateSqlHelper(connectionString);
try
{
helper.ExecuteNonQuery(sql);
} catch (Exception e)
{
Log.Warn(e);
}
Log.Debug("SQL Executed.");
}
public void Create_Normally_ShouldReturn_Transfer()
{
NewTransfer newTransfer;
Transfer transfer;
using (var dataLayer = DataLayerHelper.CreateDataLayer())
using (var categoriesController = new CategoriesController(dataLayer))
using (var currenciesController = new CurrenciesController(dataLayer))
using (var partnersController = new PartnersController(dataLayer))
using (var transfersController = new TransfersController(dataLayer))
{
var category = categoriesController.CreateCategory(TestDataProvider.CreateNewCategory());
var partner = partnersController.CreatePartner(TestDataProvider.CreateAnotherNewPartner());
var currency = currenciesController.CreateCurrency(TestDataProvider.CreateAnotherNewCurrency());
newTransfer = TestDataProvider.CreateNewTransfer(
category.Id,
partner.Id,
currency.Id,
TestDataProvider.CreateNewTransferItem());
transfer = transfersController.CreateTransfer(newTransfer);
}
Assert.AreEqual(newTransfer.CategoryId, transfer.Category.Id, "Unexpected category.");
Assert.AreEqual(newTransfer.CurrencyId, transfer.Currency.Id, "Unexpected currency.");
Assert.AreEqual(newTransfer.Discount, transfer.Discount, "Unexpected discount.");
Assert.IsTrue(transfer.Id > 0, $"Transfer ID is expected to greater than 0. Actual: {transfer.Id}.");
Assert.AreEqual(newTransfer.Items.Length, transfer.Items.Length, "Unexpected transfer item count.");
Assert.AreEqual(newTransfer.Items[0].Discount, transfer.Items[0].Discount, "Unexpected item discount.");
Assert.IsTrue(
transfer.Items[0].Id > 0,
$"Item ID is expected to greater than 0. Actual: {transfer.Items[0].Id}.");
Assert.AreEqual(newTransfer.Items[0].Name, transfer.Items[0].Name, "Unexpected item name.");
Assert.AreEqual(newTransfer.Items[0].Price, transfer.Items[0].Price, "Unexpected item price.");
Assert.AreEqual(newTransfer.Note, transfer.Note, "Unexpected note.");
Assert.AreEqual(newTransfer.PartnerId, transfer.Partner.Id, "Unexpected partner.");
Assert.AreEqual(newTransfer.Time, transfer.Time, "Unexpected time.");
Assert.AreEqual(newTransfer.Title, transfer.Title, "Unexpected title.");
}
/// <summary>
/// Wrapper around umbraco's sqlHelper.ExecuteNonQuery that handles a few exceptions
/// </summary>
/// <param name="query">The SQL Query to execute</param>
/// <param name="parameters">Dictionary mapping parameter name to parameter value</param>
/// <returns>The number of rows affected, or -1 on failure</returns>
private static int?NonQuery(string query, Dictionary <string, object> parameters)
{
int? numRows;
ISqlHelper sqlHelper = null;
try
{
sqlHelper = DataLayerHelper.CreateSqlHelper(global::Umbraco.Core.ApplicationContext.Current.DatabaseContext.ConnectionString);
var numParams = parameters.Count;
if (numParams < 1)
{
numRows = sqlHelper.ExecuteNonQuery(query);
}
else
{
var sqlParameters = new IParameter[numParams];
var i = 0;
foreach (var parameter in parameters)
{
sqlParameters[i++] = sqlHelper.CreateParameter(parameter.Key, parameter.Value);
}
numRows = sqlHelper.ExecuteNonQuery(query, sqlParameters);
}
}
catch (umbraco.UmbracoException ex)
{
LogHelper.Error(typeof(DbAccess), "Error In Database Query to fullTextCache.", ex);
numRows = null;
}
finally
{
if (sqlHelper != null)
{
sqlHelper.Dispose();
}
}
return(numRows);
}
public void Run(string configFile, string connectionString)
{
Log.Debug("Running SqlCe install");
var config = File.ReadAllText(configFile);
config = config.Replace(
"Moriyama.Workflow.Infrastructure.DatabaseHelper.SqlServerDatabaseHelper, Moriyama.Workflow",
"Moriyama.Workflow.Umbraco6.Infrastructure.UmbracoSqlCeDatabaseHelper, Moriyama.Workflow.Umbraco6");
File.WriteAllText(configFile, config);
var sql = Helper.Instance.ReadAssemblyResource("Resources.Sql.Ce.Install.sql");
Log.Debug("Read SQL from resource stream");
Log.Debug(sql);
Log.Debug("Executing SQL");
var helper = DataLayerHelper.CreateSqlHelper(connectionString);
foreach (var s in sql.Split(';'))
{
if (s.Trim().Length <= 0)
{
continue;
}
try
{
helper.ExecuteNonQuery(s);
} catch (Exception ex)
{
Log.Fatal(ex);
}
}
Log.Debug("SQL Executed.");
}
public static void UpdateCustomerUsername(string oldCustomerUsername, string newCustomerUsername)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
sqlHelper.ExecuteNonQuery("update uWebshopOrders set customerUsername = @newCustomerUserName, updateDate = @updateDate where customerUsername = @oldCustomerUserName", sqlHelper.CreateParameter("@newCustomerUserName", newCustomerUsername), sqlHelper.CreateParameter("@oldCustomerUserName", oldCustomerUsername), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
public static void UpdateCustomerId(int oldCustomerId, int newCustomerId)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
sqlHelper.ExecuteNonQuery("update uWebshopOrders set customerID = @newcustomerID, updateDate = @updateDate where customerID = @oldCustomerID", sqlHelper.CreateParameter("@newcustomerID", newCustomerId), sqlHelper.CreateParameter("@oldCustomerID", oldCustomerId), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
/// <summary>
/// Set the .Net Membership Loginname
/// </summary>
/// <param name="orderId">The order unique identifier.</param>
/// <param name="userName">Name of the user.</param>
public static void SetCustomer(Guid orderId, string userName)
{
var sqlHelper = DataLayerHelper.CreateSqlHelper(GlobalSettings.DbDSN);
sqlHelper.ExecuteNonQuery("update uWebshopOrders set customerUsername = @customerUsername, updateDate = @updateDate where uniqueID = @uniqueID", sqlHelper.CreateParameter("@uniqueID", orderId), sqlHelper.CreateParameter("@customerUsername", userName), sqlHelper.CreateParameter("@updateDate", DateTime.Now));
}
