public static long CreateTransaction(User userInfo, string itemData, ItemDataFormat itemDataFormat, TransactionType transactionType, TransactionStatus transactionStatus)
{
long transactionId = -1;
using (var context = new OnStoreEntities())
{
Transaction trans = context.Transactions.Create();
trans.TransactionId = transactionId;
trans.UserId = userInfo.UserId;
trans.ItemData = itemData;
trans.ItemDataFormat = (byte)itemDataFormat;
trans.Status = (byte)transactionStatus;
trans.TransactionDate = DateTime.UtcNow;
trans.TransactionType = (byte)transactionType;
trans.CreatedDate = DateTime.UtcNow;
context.Transactions.Add(trans);
bool created = context.SaveChanges() > 0;
if (created)
{
transactionId = trans.TransactionId;
}
}
return(transactionId);
}
public static long CreateOrderDeliveryAddressMap(long transactionId, OrderDeliveryAddressMap address)
{
long orderDeliveryAddressMapId = -1;
using (var context = new OnStoreEntities())
{
OrderDeliveryAddressMap addressMap = context.OrderDeliveryAddressMaps.Create();
addressMap.TransactionId = transactionId;
addressMap.Address = address.Address;
addressMap.City = address.City;
addressMap.Country = address.Country;
addressMap.State = address.State;
addressMap.ZipCode = address.ZipCode;
addressMap.CreatedDate = DateTime.UtcNow;
addressMap.Country = "India";
context.OrderDeliveryAddressMaps.Add(addressMap);
bool created = context.SaveChanges() > 0;
if (created)
{
orderDeliveryAddressMapId = addressMap.OrderDeliveryAddressMapId;
}
}
return(orderDeliveryAddressMapId);
}
public static User GetUser(Guid userId)
{
using (var context = new OnStoreEntities())
{
User user = context.Users.SingleOrDefault(usr => usr.UserId == userId);
return(user);
}
}
public static User GetUser(string userName)
{
using (var context = new OnStoreEntities())
{
User user = context.Users.SingleOrDefault(usr => usr.Name == userName);
return(user);
}
}
public static Transaction GetTransaction(long transactionId)
{
Transaction transaction = null;
using (var context = new OnStoreEntities())
{
transaction = context.Transactions.SingleOrDefault(t => t.TransactionId == transactionId);
if (transaction != null)
{
return(transaction);
}
}
return(transaction);
}
public static bool CreateRawReceipt(int receiptId, string rawReceipt)
{
bool created = false;
using (var context = new OnStoreEntities())
{
PurchaseRawReceipt receiptData = context.PurchaseRawReceipts.Create();
receiptData.PurchaseReceiptId = receiptId;
receiptData.RawReceipt = rawReceipt;
receiptData.CreatedDate = DateTime.UtcNow;
context.PurchaseRawReceipts.Add(receiptData);
created = context.SaveChanges() > 0;
}
return(created);
}
public static bool UpdateTransactionStatus(long transactionId, TransactionStatus status)
{
bool updated = false;
using (var context = new OnStoreEntities())
{
var transaction = context.Transactions.SingleOrDefault(t => t.TransactionId == transactionId);
if (transaction != null)
{
transaction.Status = (byte)status;
transaction.UpdatedDate = DateTime.UtcNow;
updated = context.SaveChanges() > 0;
}
}
return(updated);
}
public static string CreateToken(User userInfo)
{
string token = string.Empty;
using (var context = new OnStoreEntities())
{
UserLogin userLogin = context.UserLogins.Create();
userLogin.UserId = userInfo.UserId;
userLogin.LoggedInFrom = "PC";
userLogin.Token = System.Guid.NewGuid().ToString();
userLogin.ExpiresAt = DateTime.UtcNow.AddHours(EXPIRATION_DURATION);
userLogin.CreatedDate = DateTime.UtcNow;
context.UserLogins.Add(userLogin);
if (context.SaveChanges() > 0)
{
token = userLogin.Token;
}
}
return(token);
}
public static User CreateUser(RegistrationRequest registrationRequest)
{
User user = null;
using (var context = new OnStoreEntities())
{
user = context.Users.Create();
user.FirstName = registrationRequest.FirstName;
if (!string.IsNullOrWhiteSpace(registrationRequest.LastName))
{
user.LastName = registrationRequest.LastName;
}
user.PrimaryEmail = registrationRequest.PrimaryEmail;
if (!string.IsNullOrWhiteSpace(registrationRequest.SecondaryEmail))
{
user.SecondaryEmail = registrationRequest.SecondaryEmail;
}
user.PrimaryContactNo = registrationRequest.PrimaryContactNo;
if (!string.IsNullOrWhiteSpace(registrationRequest.SecondaryContactNo))
{
user.SecondaryContactNo = registrationRequest.SecondaryContactNo;
}
user.Name = registrationRequest.UserName;
user.Password = CryptoHelper.ComputeSHA256Hash(registrationRequest.Password.ToLowerInvariant());
user.UserId = System.Guid.NewGuid();
user.IsActive = true;
user.IsMember = false;
user.CreatedDate = DateTime.UtcNow;
context.Users.Add(user);
int affectedRecords = context.SaveChanges();
if (affectedRecords <= 0)
{
user = null;
}
}
return(user);
}
public static int CreateReceipt(Guid userId, long transactionId, string vendorTransactionId, TransactionType transactionType, TransactionProvider provider, TransactionStatus transactionStatus)
{
int receiptId = 0;
using (var context = new OnStoreEntities())
{
PurchaseReceipt receipt = context.PurchaseReceipt.Create();
receipt.TransactionId = transactionId;
receipt.UserId = userId;
receipt.VendorTransactionId = vendorTransactionId;
receipt.TransactionStatus = (byte)transactionStatus;
receipt.TransactionProvider = (byte)provider;
receipt.TransactionType = (byte)transactionType;
receipt.CreatedDate = DateTime.UtcNow;
context.PurchaseReceipt.Add(receipt);
if (context.SaveChanges() > 0)
{
return(receipt.PurchaseReceiptId);
}
}
return(receiptId);
}
internal static List <ItemStoreMap> GetItemsInStore(int storeId)
{
List <ItemStoreMap> storeItems = new List <ItemStoreMap>();
using (var context = new OnStoreEntities())
{
storeItems = context.ItemStoreMaps
.Where(ism => ism.StoreId == storeId && ism.Item.Active)
.Include(ism => ism.Item)
.Include(ism => ism.Item.ItemCategoryMaps)
.Include(ism => ism.Item.ItemPriceMaps)
.Include(ism => ism.Item.ItemVendorPrices)
.Include(ism => ism.Item.ItemVideoMaps)
.Include(ism => ism.Item.ItemImageMaps)
.Include(ism => ism.Store)
.Include(ism => ism.ItemsAvailabilities)
.Include(ism => ism.ItemStorePriceDiscounts)
.Include(ism => ism.ItemStorePriceDiscounts.Select(ispc => ispc.PriceDiscount))
.ToList();
}
return(storeItems);
}
