public void Add(string itemNumber, char caseOrPackage, string orderSource, string cartId, string productGroupingInsightKey)
{
var orderSourceId = connection.Query <int>(
@"select OrderSourceId
from Orders.RecommendedOrderSource
where OrderSource = @OrderSource",
new
{
OrderSource = orderSource
}).FirstOrDefault();
connection.Execute(
@"INSERT INTO [Orders].[RecommendedItemsOrderedAnalytics]
([CartId],[ItemNumber],[UnitOfMeasure],[OrderSourceId],[ProductGroupingInsightKey])
VALUES
(@CartId,@ItemNumber,@UnitOfMeasure,@OrderSourceId,@ProductGroupingInsightKey)",
new
{
CartId = cartId,
ItemNumber = itemNumber,
ProductGroupingInsightKey = productGroupingInsightKey,
UnitOfMeasure = caseOrPackage,
OrderSourceId = orderSourceId
});
}
/// <summary>
/// Create a feedback row for the user
/// </summary>
/// <param name="user"></param>
/// <param name="userFeedback"></param>
public void SaveUserFeedback(UserFeedbackContext context, Core.Models.UserFeedback.UserFeedback userFeedback)
{
if (context == null)
{
throw new ArgumentNullException("context");
}
if (userFeedback == null)
{
throw new ArgumentNullException("userFeedback");
}
string sqlCommand = @"
INSERT INTO [Messaging].[UserFeedback]
(
[UserId]
,[UserFirstName]
,[UserLastName]
,[BranchId]
,[CustomerNumber]
,[CustomerName]
,[SalesRepName]
,[Audience]
,[SourceName]
,[TargetName]
,[SourceEmailAddress]
,[TargetEmailAddress]
,[Subject]
,[Content]
,[BrowserUserAgent]
,[BrowserVendor]
)
OUTPUT Inserted.Id
VALUES
(
@UserId
,@UserFirstName
,@UserLastName
,@BranchId
,@CustomerNumber
,@CustomerName
,@SalesRepName
,@Audience
,@SourceName
,@TargetName
,@SourceEmailAddress
,@TargetEmailAddress
,@Subject
,@Content
,@BrowserUserAgent
,@BrowserVendor
)
SELECT SCOPE_IDENTITY()
";
var parameters =
new
{
UserId = context.UserId,
UserFirstName = context.UserFirstName,
UserLastName = context.UserLastName,
BranchId = context.BranchId,
CustomerNumber = context.CustomerNumber,
CustomerName = context.CustomerName,
SalesRepName = context.SalesRepName,
SourceName = context.SourceName,
TargetName = context.TargetName,
SourceEmailAddress = context.SourceEmailAddress,
TargetEmailAddress = context.TargetEmailAddress,
Subject = userFeedback.Subject,
Content = userFeedback.Content,
Audience = userFeedback.Audience.ToString(),
BrowserUserAgent = userFeedback.BrowserUserAgent,
BrowserVendor = userFeedback.BrowserVendor,
};
_dbConnection.Execute(sqlCommand, parameters);
}