public IEnumerable <Category> GetCategories()
{
using (var conn = _context.OpenConnection())
{
var result = conn.Query <Category>(
"category_get_all",
commandType: CommandType.StoredProcedure);
return(result);
}
}
public int DeleteAddress(int id)
{
using (var conn = _context.OpenConnection())
{
var param = new DynamicParameters();
param.Add("@Id", id);
var result = conn.Execute(
"address_delete_by_id",
param: param,
commandType: CommandType.StoredProcedure);
return(result);
}
}
public Customer GetCustomerById(int id)
{
using (var conn = _context.OpenConnection())
{
var param = new DynamicParameters();
param.Add("@Id", id);
var customer = conn.Query <Customer>(
"get_customer_by_id",
param: param,
commandType: CommandType.StoredProcedure).FirstOrDefault();
return(customer);
}
}
public CustomerSession GetCustomerSessionByGuid(Guid customerSessionGuid)
{
using (var conn = _context.OpenConnection())
{
var param = new DynamicParameters();
param.Add("@CustomerSessionGuid", customerSessionGuid);
var result = conn.Query <CustomerSession>(
"customersession_get_by_guid",
param: param,
commandType: CommandType.StoredProcedure).FirstOrDefault();
return(result);
}
}
/// <summary>
/// Inserts an activity log type item
/// </summary>
/// <param name="activityLogType">Activity log type item</param>
public void InsertActivityType(ActivityLogType activityLogType)
{
if (activityLogType == null)
{
throw new ArgumentNullException("activityLogType");
}
activityLogType.SystemKeyword = CommonHelper.EnsureNotNull(activityLogType.SystemKeyword);
activityLogType.SystemKeyword = CommonHelper.EnsureMaximumLength(activityLogType.SystemKeyword, 50);
activityLogType.Name = CommonHelper.EnsureNotNull(activityLogType.Name);
activityLogType.Name = CommonHelper.EnsureMaximumLength(activityLogType.Name, 100);
using (var connection = _context.OpenConnection())
{
connection.Execute(new CommandDefinition());
}
if (this.CacheEnabled)
{
_cacheManager.RemoveByPattern(ACTIVITYTYPE_PATTERN_KEY);
}
}