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); }