public static long GenerateNewOrderNumber(long storeId)
{
try
{
Data.EF.EntityFrameworkDevConnectionString ef = new Data.EF.EntityFrameworkDevConnectionString(WebAppSettings.ApplicationConnectionStringForEntityFramework);
ObjectResult<long?> results = ef.GenerateNewOrderNumber(storeId);
if (results != null)
{
long? number = results.FirstOrDefault();
if (number != null)
{
if (number.HasValue)
{
return number.Value;
}
}
}
}
catch (Exception ex)
{
EventLog.LogEvent(ex);
return 0;
}
return 0;
}
public static long GenerateNewOrderNumber(long storeId)
{
try
{
Data.EF.EntityFrameworkDevConnectionString ef = new Data.EF.EntityFrameworkDevConnectionString(WebAppSettings.ApplicationConnectionStringForEntityFramework);
ObjectResult <long?> results = ef.GenerateNewOrderNumber(storeId);
if (results != null)
{
long?number = results.FirstOrDefault();
if (number != null)
{
if (number.HasValue)
{
return(number.Value);
}
}
}
}
catch (Exception ex)
{
EventLog.LogEvent(ex);
return(0);
}
return(0);
}
public OrderSummary(long storeId)
{
NewOrderCount = 0;
OnHoldOrderCount = 0;
ReadyForPaymentOrderCount = 0;
ReadyForShippingOrderCount = 0;
try
{
Data.EF.EntityFrameworkDevConnectionString ef = new Data.EF.EntityFrameworkDevConnectionString(WebAppSettings.ApplicationConnectionStringForEntityFramework);
var result = ef.bvc_Order.Where(y => y.IsPlaced == 1)
.Where(y => y.StoreId == storeId)
.GroupBy(y => y.StatusCode)
.Select(grouping => grouping.Select(y => new OrderSummaryData()
{
StatusCode = y.StatusCode,
OrderCount = grouping.Count()
})
.FirstOrDefault())
.OrderBy(y => y.StatusCode);
if (result != null)
{
foreach (OrderSummaryData stat in result)
{
if (stat.StatusCode == Orders.OrderStatusCode.Received)
{
this.NewOrderCount = stat.OrderCount;
}
if (stat.StatusCode == Orders.OrderStatusCode.OnHold)
{
this.OnHoldOrderCount = stat.OrderCount;
}
if (stat.StatusCode == Orders.OrderStatusCode.ReadyForPayment)
{
this.ReadyForPaymentOrderCount = stat.OrderCount;
}
if (stat.StatusCode == Orders.OrderStatusCode.ReadyForShipping)
{
this.ReadyForShippingOrderCount = stat.OrderCount;
}
}
}
}
catch (Exception ex)
{
EventLog.LogEvent(ex);
}
}
public OrderSummary(long storeId)
{
NewOrderCount = 0;
OnHoldOrderCount = 0;
ReadyForPaymentOrderCount = 0;
ReadyForShippingOrderCount = 0;
try
{
Data.EF.EntityFrameworkDevConnectionString ef = new Data.EF.EntityFrameworkDevConnectionString(WebAppSettings.ApplicationConnectionStringForEntityFramework);
var result = ef.bvc_Order.Where(y => y.IsPlaced == 1)
.Where(y => y.StoreId == storeId)
.GroupBy(y => y.StatusCode)
.Select(grouping => grouping.Select(y => new OrderSummaryData()
{
StatusCode = y.StatusCode,
OrderCount = grouping.Count()
})
.FirstOrDefault())
.OrderBy(y => y.StatusCode);
if (result != null)
{
foreach (OrderSummaryData stat in result)
{
if (stat.StatusCode == Orders.OrderStatusCode.Received)
{
this.NewOrderCount = stat.OrderCount;
}
if (stat.StatusCode == Orders.OrderStatusCode.OnHold)
{
this.OnHoldOrderCount = stat.OrderCount;
}
if (stat.StatusCode == Orders.OrderStatusCode.ReadyForPayment)
{
this.ReadyForPaymentOrderCount = stat.OrderCount;
}
if (stat.StatusCode == Orders.OrderStatusCode.ReadyForShipping)
{
this.ReadyForShippingOrderCount = stat.OrderCount;
}
}
}
}
catch (Exception ex)
{
EventLog.LogEvent(ex);
}
}
public RewardPointsProviderDatabase()
{
ef = new Data.EF.EntityFrameworkDevConnectionString(WebAppSettings.ApplicationConnectionStringForEntityFramework);
}
public RewardPointsProviderDatabase()
{
ef = new Data.EF.EntityFrameworkDevConnectionString(WebAppSettings.ApplicationConnectionStringForEntityFramework);
}
