public List <ArtistsModel> GetFilterArtists(List <ProductSummaryModel> products) { List <int> artistIds = new List <int>(); if (products != null && products.Count() > 0) { artistIds = products.Select(s => s.ArtistId).Distinct().ToList(); using (var dataContext = new BrownBagDataEntities()) { var selectedArtists = dataContext.Artists.Where(a => artistIds.Any(b => b == a.Id)) .AsEnumerable() .Select(s => new ArtistsModel { ArtistsId = s.Id, Description = s.Description ?? "", ArtistName = s.Artists ?? "", PictureURL = s.PictureURL ?? "", ProductCount = products.Where(a => a.ArtistId == s.Id).Count() }).ToList(); return(selectedArtists); } } else { return(null); } }
public List <BrandModel> GetFilterBrand(List <ProductSummaryModel> products) { List <int> brandIds = new List <int>(); if (products != null && products.Count() > 0) { brandIds = products.Select(s => s.ManufacturerId).Distinct().ToList(); using (var dataContext = new BrownBagDataEntities()) { var selectedBrands = dataContext.Manufacturers.Where(a => brandIds.Any(b => b == a.Id)) .AsEnumerable() .Select(s => new BrandModel { BrandId = s.Id, Description = s.Description ?? "", BrandName = s.ManufacturerName ?? "", DisplayOrder = s.DisplayOrder ?? 0, PictureURL = s.PictureURL ?? "", ProductCount = products.Where(a => a.ManufacturerId == s.Id).Count() }).ToList(); return(selectedBrands); } } else { return(null); } }
public List <VendorsModel> GetFilterVendors(List <ProductSummaryModel> products) { List <int> vendorIds = new List <int>(); if (products != null && products.Count() > 0) { vendorIds = products.Select(s => s.VendorId).Distinct().ToList(); using (var dataContext = new BrownBagDataEntities()) { var selectedArtists = dataContext.Vendors.Where(a => vendorIds.Any(b => b == a.Id)) .AsEnumerable() .Select(s => new VendorsModel { VendorId = s.Id, Description = s.Description ?? "", VendorName = s.VendorName ?? "", PictureURL = s.PictureURL ?? "", VendorAddress = s.VendorAddress ?? "", VendorEmail = s.VendorEmail ?? "", ProductCount = products.Where(a => a.VendorId == s.Id).Count() }).ToList(); return(selectedArtists); } } else { return(null); } }
public List <CategoryModel> GetFilterCategory(List <ProductSummaryModel> products) { List <int> categoryIds = new List <int>(); if (products != null && products.Count() > 0) { categoryIds = products.Select(s => s.CategoryId).Distinct().ToList(); using (var dataContext = new BrownBagDataEntities()) { var selectedCategories = dataContext.Categories.Where(a => categoryIds.Any(b => b == a.Id)).ToList(); var rootIds = selectedCategories.Select(s => s.RootCategory ?? 0).Distinct().ToList(); return(dataContext.Categories.Where(w => rootIds.Any(r => r == w.RootCategory)) .AsEnumerable() .Select(s => new CategoryModel { CategoryId = s.Id, CategoryDescription = s.Description ?? "", CategoryName = s.Name ?? "", DisplayOrder = s.Display_Order ?? 0, ParentCategoryId = s.ParentCategoryId ?? 0, PictureUrl = s.PictureUrl ?? "", RootCategoryId = s.RootCategory ?? 0, RootTree = s.TempPID ?? "", ProductCount = products.Where(a => a.CategoryId == s.Id).Count() }).ToList()); } } else { return(null); } }
public CustomerSummary GetCustomerByEmail(string email) { try { var customerSummary = new CustomerSummary(); using (var dataContext = new BrownBagDataEntities()) { var customerData = dataContext.Customers.Where(a => a.Email == email).ToList(); if (customerData != null && customerData.Count() > 0) { var otherData = dataContext.CustomerAttributes.Where(a => a.Customer_Email == email).FirstOrDefault(); customerSummary.IsVerifiedCustomer = customerData.Where(a => a.Email == email && a.Active == 1).Count() > 0 ? true : false; customerSummary.CustomerName = otherData.Customer_Name ?? ""; customerSummary.CustomerEmail = otherData.Customer_Email ?? ""; customerSummary.CustomerContactNumber = otherData.Customer_Phone ?? ""; customerSummary.CustomerId = customerData.FirstOrDefault().CustomerGuid.Value; customerSummary.IsExclusiveUser = (customerData.FirstOrDefault().IsSystemAccount ?? 0) > 0 ? true : false; } else { return(null); } } return(customerSummary); } catch { throw; } }
public List <BannerModel> GetAllBanners() { try { using (var dataContext = new BrownBagDataEntities()) { var banners = dataContext.Banners .Select(s => new BannerModel { Id = s.Id, Sequences = s.Sequences == null ? 0 : s.Sequences.Value, BannerLink = s.BannerLink ?? "", BannerText = s.BannerText ?? "", BannerURL = s.BannerURL ?? "" }) .OrderBy(o => o.Sequences).ToList(); return(banners); } } catch { throw; } }
public OtpDetail GetUnverifiedOtp(string email) { try { using (var dataContext = new BrownBagDataEntities()) { DateTime currentTime = DateTime.Now.ToUniversalTime(); var latestOtp = dataContext.OtpDetails .Where(a => a.Email == email && a.IsActive == true && a.IsVerified == false && a.IssueDate <currentTime && a.ExpiryDate> currentTime) .OrderByDescending(o => o.Id).FirstOrDefault(); if (latestOtp != null) { return(latestOtp); } else { return(null); } } } catch { throw; } }
public bool CustomerLogIn(string deviceId, string password, string email) { try { bool isLogin = false; using (var dataContext = new BrownBagDataEntities()) { if (!string.IsNullOrEmpty(deviceId) && !string.IsNullOrEmpty(email) && !string.IsNullOrEmpty(password)) { var deviceData = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceId).FirstOrDefault(); var customerData = dataContext.Customers.Where(a => a.Email == email).FirstOrDefault(); if (customerData != null) { var passwordData = dataContext.CustomerPasswords.Where(a => a.Password == password && a.CustomerId == customerData.CustomerGuid).FirstOrDefault(); if (deviceData != null && passwordData != null) { isLogin = true; deviceData.RefCustomerGuid = customerData.CustomerGuid; } } } isLogin = dataContext.SaveChanges() > 0 ? true : false; } return(isLogin); } catch { throw; } }
public bool AddNewAddress(Model.CustomerDetailAttribute customerAddress) { try { using (var dataContext = new BrownBagDataEntities()) { dataContext.CustomerAttributes.Add(new DataEntity.CustomerAttribute { Customer_Id = customerAddress.Customer_Id, Customer_Email = customerAddress.Customer_Email, Customer_Phone = customerAddress.Customer_Phone, OTP_Verified = 0, Modified_Date = DateTime.Now.ToUniversalTime(), Customer_Name = customerAddress.Customer_Name, Customer_Active = customerAddress.Customer_Active, Created_Date = DateTime.Now.ToUniversalTime(), Created_By = customerAddress.Customer_Email }); return(dataContext.SaveChanges() > 0 ? true : false); } } catch { throw; } }
public bool CustomerLogOff(string deviceId) { try { bool isLogOff = false; using (var dataContext = new BrownBagDataEntities()) { if (!string.IsNullOrEmpty(deviceId)) { var deviceData = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceId).FirstOrDefault(); if (deviceData != null) { isLogOff = true; deviceData.RefCustomerGuid = null; deviceData.UpdatedOnUtc = DateTime.Now.ToUniversalTime(); } } isLogOff = dataContext.SaveChanges() > 0 ? true : false; } return(isLogOff); } catch { throw; } }
public DeviceRegistrationModel GetDeviceByDeviceId(string deviceId) { try { using (var dataContext = new BrownBagDataEntities()) { return(dataContext.DeviceRegistrations .Where(w => w.IMEI_Number == deviceId).AsEnumerable() .Select(s => new DeviceRegistrationModel { AccessToken = s.AccessToken ?? "", Id = s.Id, CustomerGuid = s.RefCustomerGuid != null ? s.RefCustomerGuid.Value.ToString() : "", IMEINumber = s.IMEI_Number, IsActive = s.IsActive, CreatedOn = s.CreatedOnUtc.ToUniversalTime(), UpdatedOn = s.UpdatedOnUtc != null ? s.UpdatedOnUtc.Value : DateTime.Now.ToUniversalTime() }) .FirstOrDefault()); } } catch { throw; } }
public bool AddDeviceRegistration(DeviceRegistrationModel device) { try { using (var dataContext = new BrownBagDataEntities()) { var deviceRegistration = new DeviceRegistration { AccessToken = device.AccessToken.Trim(), CreatedOnUtc = DateTime.Now.ToUniversalTime(), IMEI_Number = device.IMEINumber.Trim(), IsActive = true, RefCustomerGuid = string.IsNullOrEmpty(device.CustomerGuid) ? (Guid?)null : Guid.Parse(device.CustomerGuid), UpdatedOnUtc = DateTime.Now.ToUniversalTime() }; dataContext.DeviceRegistrations.Add(deviceRegistration); return(dataContext.SaveChanges() > 0 ? true : false); } } catch { throw; } }
public bool EditDeviceRegistration(DeviceRegistrationModel device) { try { using (var dataContext = new BrownBagDataEntities()) { var selectedDevice = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == device.IMEINumber).FirstOrDefault(); if (selectedDevice != null) { selectedDevice.AccessToken = device.AccessToken.Trim(); selectedDevice.UpdatedOnUtc = DateTime.Now.ToUniversalTime(); return(dataContext.SaveChanges() > 0 ? true : false); } else { return(false); } } } catch { throw; } }
public bool AddNewOTP(OtpDetailsModel OtpDetailsModel) { try { using (var dataContext = new BrownBagDataEntities()) { dataContext.OtpDetails.Add(new DataEntity.OtpDetail { Email = OtpDetailsModel.Email, ExpiryDate = OtpDetailsModel.ExpiryDate, IsActive = OtpDetailsModel.IsActive, IsVerified = OtpDetailsModel.IsVerified, OTP = OtpDetailsModel.OTP, Prupose = OtpDetailsModel.Prupose, IssueDate = OtpDetailsModel.IssueDate, RefCustomerGuid = OtpDetailsModel.RefCustomerGuid }); return(dataContext.SaveChanges() > 0 ? true : false); } } catch { throw; } }
public bool ChangeCustomerPassword(string deviceId, string password, string email) { try { bool isSave = false; using (var dataContext = new BrownBagDataEntities()) { if (!string.IsNullOrEmpty(deviceId) && string.IsNullOrEmpty(email)) { var deviceData = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceId).FirstOrDefault(); if (deviceData != null) { var passwordDetails = dataContext.CustomerPasswords.Where(a => a.CustomerId == deviceData.RefCustomerGuid).FirstOrDefault(); passwordDetails.Password = password; } } else if (string.IsNullOrEmpty(deviceId) && !string.IsNullOrEmpty(email)) { var emailData = dataContext.Customers.Where(a => a.Email == email).FirstOrDefault(); if (emailData != null) { var passwordDetails = dataContext.CustomerPasswords.Where(a => a.CustomerId == emailData.CustomerGuid ).FirstOrDefault(); passwordDetails.Password = password; } } isSave = dataContext.SaveChanges() > 0 ? true : false; } return(isSave); } catch { throw; } }
public CartItemSummary ShowCartItems(string deviceNumber, string cuponCode) { try { var items = new List <CartItemDetails>(); using (var dataContext = new BrownBagDataEntities()) { var userInfo = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceNumber).FirstOrDefault(); if (userInfo != null && userInfo.RefCustomerGuid != null) { var cartListItems = dataContext.ShoppingCartItems.Where(a => a.Customer_Id == userInfo.RefCustomerGuid).ToList(); if (cartListItems != null && cartListItems.Count() > 0) { cartListItems.ForEach(x => { var product = dataContext.Products.Where(a => a.Id == x.ProductId).FirstOrDefault(); if (product != null) { items.Add(new CartItemDetails { CurrencyType = x.Currency ?? "", Price = x.ProductPrice ?? 0, ProductId = x.ProductId ?? 0, ProductName = product.ProductName ?? "", Stock = product.Stock ?? 0, StockStatus = (product.Stock ?? 0) > 1 ? StockStatus.InStock.GetDescription() : (product.Stock ?? 0) == 1 ? StockStatus.LowStock.GetDescription() : StockStatus.OutOfStock.GetDescription(), ProductImages = dataContext.ProductImages.Where(b => b.ProductID == product.Id).Select(s => new Model.ProductImage { Id = s.Id, GalleryImageURL = s.GalleryImageURL ?? "", ImageURL = s.ImageURL ?? "", Sequences = s.Sequences ?? 0, ThumbImageURL = s.ThumbImageURL ?? "" }).ToList() }); } }); return(new CartItemSummary { CartItems = items, CartCalculation = CalculateCartPrice(items, cuponCode, userInfo.RefCustomerGuid.Value, dataContext) }); } else { return(null); } } else { return(null); } } } catch { throw; } }
public List <CustomerAddressDetails> GetAddresses(string deviceNo) { try { using (var dataContext = new BrownBagDataEntities()) { var device = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceNo).FirstOrDefault(); if (device == null) { return(null); } if (device.RefCustomerGuid == null) { return(null); } var addresses = dataContext.Addresses .Where(a => a.CustomerGUID == device.RefCustomerGuid && a.Status == 1) .Select(s => new CustomerAddressDetails { City = s.City ?? "", Country = s.Country ?? "", Id = s.Id, State = s.State ?? "", StreetAddress1 = s.StreetAddress1 ?? "", StreetAddress2 = s.StreetAddress2 ?? "", ZipCode = s.ZipCode ?? "" }).ToList(); var relatedDetails = dataContext.Customers .Where(a => a.CustomerGuid == device.RefCustomerGuid && addresses.Any(b => b.Id == a.ShippingAddress_Id || b.Id == a.BillingAddress_Id)) .ToList(); if (relatedDetails != null && relatedDetails.Count() > 0) { addresses.ForEach(x => { if (relatedDetails.Where(y => y.BillingAddress_Id == x.Id).Count() > 0) { x.UseAsBillingAddress = true; } if (relatedDetails.Where(y => y.ShippingAddress_Id == x.Id).Count() > 0) { x.UseAsShipingAddress = true; } }); } return(addresses); } } catch { throw; } }
public List <ProductSummaryModel> GetProducts(SearchProductModel search, string deviceNo, bool isFeaturedProducts) { try { CurrencyTypeName currencyTypeName = search.CurrencyName; using (var dataContext = new BrownBagDataEntities()) { var isExclusiveUser = CheckExclusiveUser(dataContext, deviceNo.Trim()); var ratings = dataContext.Ratings.GroupBy(g => g.ProductID).Select(s2 => new { ProductId = s2.Key, Average = s2.Average(p => p.Rating1 ?? 0), ReviewCount = s2.Where(w => string.IsNullOrEmpty(w.Review)).Count() }).ToList(); var products = dataContext.Products .Where(w => (isFeaturedProducts == false || w.IsRental == (isFeaturedProducts == true ? 1 : 0)) && w.Published == 1 && (isExclusiveUser == true || w.IsExclusive == (isExclusiveUser == true ? 1 : 0)) && (search.CategoryIds.Count == 0 || (search.CategoryIds.Any(k => k == (w.CategoryID ?? 0)))) && (search.BrandIds.Count == 0 || (search.BrandIds.Any(k => k == (w.ManufacturerID ?? 0)))) && (search.ArtistIds.Count == 0 || (search.ArtistIds.Any(k => k == (w.ArtistID ?? 0)))) && (search.VendorIds.Count == 0 || (search.VendorIds.Any(k => k == (w.VendorID ?? 0)))) && (search.ProductSearchText == null || search.ProductSearchText == "" || w.FullDescription.Contains(search.ProductSearchText) || w.ShortDescription.Contains(search.ProductSearchText) || w.ProductName.Contains(search.ProductSearchText)) ).AsEnumerable() .Select(s => new ProductSummaryModel { Id = s.Id, CategoryId = s.CategoryID ?? 0, ManufacturerId = s.ManufacturerID ?? 0, ArtistId = s.ArtistID ?? 0, VendorId = s.VendorID ?? 0, CurrencyType = currencyTypeName.ToString(), FullDescription = s.FullDescription ?? "", ProductName = s.ProductName ?? "", ShortDescription = s.ShortDescription ?? "", Discount = s.Discount ?? 0, Stock = s.Stock ?? 0, IsExclusive = (s.IsExclusive ?? 0) == 1 ? true : false, Price = (currencyTypeName == CurrencyTypeName.INR) ? s.CP_INR ?? 0 : (currencyTypeName == CurrencyTypeName.USD) ? s.CP_USD ?? 0 : (currencyTypeName == CurrencyTypeName.EURO) ? s.CP_Euro ?? 0 : s.CP_GBP ?? 0, ProductImages = dataContext.ProductImages.Where(x => x.ProductID == s.Id).Select(s1 => new Model.ProductImage { Id = s1.Id, GalleryImageURL = s1.GalleryImageURL, ImageURL = s1.ImageURL, ThumbImageURL = s1.ThumbImageURL, Sequences = s1.Sequences ?? 0 }).OrderBy(o => o.Sequences).ToList(), Rating = ratings.Where(w1 => w1.ProductId == s.Id).Count() > 0 ? ratings.Where(w1 => w1.ProductId == s.Id).FirstOrDefault().Average : 0, ReviewCount = ratings.Where(w1 => w1.ProductId == s.Id).Count() > 0 ? ratings.Where(w1 => w1.ProductId == s.Id).FirstOrDefault().ReviewCount : 0, }) .ToList(); return(products); } } catch { throw; } }
public List <WishListItem> ShowWishListItems(string deviceNumber) { try { List <WishListItem> items = new List <WishListItem>(); using (var dataContext = new BrownBagDataEntities()) { var userInfo = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceNumber).FirstOrDefault(); if (userInfo != null && userInfo.RefCustomerGuid != null) { var wishListItems = dataContext.Wishlists.Where(a => a.CustomerGUID == userInfo.RefCustomerGuid.ToString()).ToList(); if (wishListItems != null && wishListItems.Count() > 0) { wishListItems.ForEach(x => { var product = dataContext.Products.Where(a => a.Id == x.ProductID).FirstOrDefault(); if (product != null) { items.Add(new WishListItem { CurrencyType = x.Currency ?? "", Price = x.ProductPrice ?? 0, ProductId = x.ProductID ?? 0, ProductName = product.ProductName ?? "", Stock = product.Stock ?? 0, StockStatus = (product.Stock ?? 0) > 1 ? StockStatus.InStock.GetDescription() : (product.Stock ?? 0) == 1 ? StockStatus.LowStock.GetDescription() : StockStatus.OutOfStock.GetDescription(), ProductImages = dataContext.ProductImages.Where(b => b.ProductID == product.Id).Select(s => new Model.ProductImage { Id = s.Id, GalleryImageURL = s.GalleryImageURL ?? "", ImageURL = s.ImageURL ?? "", Sequences = s.Sequences ?? 0, ThumbImageURL = s.ThumbImageURL ?? "" }).ToList() }); } }); return(items); } else { return(null); } } else { return(null); } } } catch { throw; } }
public bool AddToCart(int productId, CurrencyTypeName currencyTypeName, string deviceNumber) { try { using (var dataContext = new BrownBagDataEntities()) { var userInfo = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceNumber).FirstOrDefault(); if (userInfo != null && userInfo.RefCustomerGuid != null) { var product = dataContext.Products.Where(a => a.Id == productId).FirstOrDefault(); if (product != null) { if (product.Stock > 0) { var itemPrice = (currencyTypeName == CurrencyTypeName.INR) ? product.CP_INR ?? 0 : (currencyTypeName == CurrencyTypeName.USD) ? product.CP_USD ?? 0 : (currencyTypeName == CurrencyTypeName.EURO) ? product.CP_Euro ?? 0 : product.CP_GBP ?? 0; ShoppingCartItem cartItem = new ShoppingCartItem { CreatedOnUtc = DateTime.Now.ToUniversalTime(), UpdatedOnUtc = DateTime.Now.ToUniversalTime(), Currency = currencyTypeName.ToString(), Customer_Id = userInfo.RefCustomerGuid.Value, ProductId = productId, ProductPrice = itemPrice, Quantity = 1, RevisedPrice = 0 }; dataContext.ShoppingCartItems.Add(cartItem); return(dataContext.SaveChanges() > 0 ? true : false); } else { return(false); } } else { return(false); } } else { return(false); } } } catch { throw; } }
public List <EmailConfig> GetEmailConfig() { try { using (var dataContext = new BrownBagDataEntities()) { return(dataContext.EmailConfigs.ToList()); } } catch { throw; } }
public bool AddNewCoustomer(CustomerBasicDetails customerBasicDetails, Guid customerId) { try { using (var dataContext = new BrownBagDataEntities()) { var customer = new BrownBagService.DataAccess.DataEntity.Customer { Active = 0, AdminComment = null, AffiliateId = 0, IsTaxExempt = 0, VendorId = 0, CannotLoginUntilDateUtc = DateTime.Now.ToUniversalTime(), Deleted = 0, Email = customerBasicDetails.Email.Trim(), EmailToRevalidate = null, Username = customerBasicDetails.Email.Trim(), CustomerGuid = customerId, BillingAddress_Id = null, FailedLoginAttempts = 0, HasShoppingCartItems = 0, IsSystemAccount = 0, ShippingAddress_Id = null, LastActivityDateUtc = DateTime.Now.ToUniversalTime(), LastIpAddress = null, LastLoginDateUtc = null, RequireReLogin = 0, RegisteredInStoreId = 1, SystemName = null, CreatedOnUtc = DateTime.Now.ToUniversalTime(), }; dataContext.Customers.Add(customer); int rowCount = dataContext.SaveChanges(); if (rowCount > 0) { dataContext.Customer_CustomerRole_Mapping.Add(new Customer_CustomerRole_Mapping { CustomerRole_Id = 3, Customer_Id = customer.Id }); } return(dataContext.SaveChanges() > 0 ? true : false); } } catch { throw; } }
public bool VerifyOTP(string otp, string email) { try { using (var dataContext = new BrownBagDataEntities()) { DateTime currentTime = DateTime.Now.ToUniversalTime(); var latestOtp = dataContext.OtpDetails .Where(a => a.Email == email && a.OTP == otp && a.IsActive == true && a.IsVerified == false && a.IssueDate <currentTime && a.ExpiryDate> currentTime) .OrderByDescending(o => o.Id).FirstOrDefault(); if (latestOtp != null) { latestOtp.IsActive = false; latestOtp.IsVerified = true; int rows = dataContext.SaveChanges(); if (rows > 0) { var customer = dataContext.Customers.Where(a => a.CustomerGuid == latestOtp.RefCustomerGuid).FirstOrDefault(); if (customer != null) { customer.Active = 1; customer.LastActivityDateUtc = DateTime.Now.ToUniversalTime(); dataContext.SaveChanges(); } var customerProfile = dataContext.CustomerAttributes.Where(a => a.Customer_Id == latestOtp.RefCustomerGuid).FirstOrDefault(); if (customerProfile != null) { customerProfile.OTP_Verified = 1; customerProfile.Modified_Date = DateTime.Now.ToUniversalTime(); dataContext.SaveChanges(); } } return(true); } else { return(false); } } } catch { throw; } }
private bool CheckExclusiveUser(BrownBagDataEntities dataContext, string deviceNo) { bool IsExclusiveUser = false; var deviceInfo = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceNo).FirstOrDefault(); if (deviceInfo != null && deviceInfo.RefCustomerGuid != null) { var userInfo = dataContext.Customers.Where(a => a.CustomerGuid == deviceInfo.RefCustomerGuid).FirstOrDefault(); if (userInfo != null) { IsExclusiveUser = (userInfo.IsSystemAccount ?? 0) > 0 ? true : false; } } return(IsExclusiveUser); }
public bool DeleteAddress(string deviceNo, int id) { try { using (var dataContext = new BrownBagDataEntities()) { var device = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceNo).FirstOrDefault(); if (device == null) { return(false); } if (device.RefCustomerGuid == null) { return(false); } var address = dataContext.Addresses .Where(a => a.Id == id && a.CustomerGUID == device.RefCustomerGuid && a.Status == 1) .FirstOrDefault(); var relatedDetail = dataContext.Customers .Where(a => a.CustomerGuid == device.RefCustomerGuid && a.ShippingAddress_Id == address.Id || a.BillingAddress_Id == address.Id) .FirstOrDefault(); if (relatedDetail != null) { if (relatedDetail.BillingAddress_Id == address.Id) { relatedDetail.BillingAddress_Id = null; } if (relatedDetail.ShippingAddress_Id == address.Id) { relatedDetail.ShippingAddress_Id = null; } } dataContext.Addresses.Remove(address); dataContext.SaveChanges(); return(true); } } catch { throw; } }
public List <ProductBasicModel> GetProductSuggestions() { try { using (var dataContext = new BrownBagDataEntities()) { return(dataContext.Products.Where(w => (w.Published ?? 0) == 1).Select(s => new ProductBasicModel { Id = s.Id, ProductName = s.ProductName ?? "" }).ToList()); } } catch { throw; } }
public List <RootCategoryModel> GetRootCategories() { using (var dataContext = new BrownBagDataEntities()) { var rootCategories = dataContext.Categories.Where(a => a.Id == a.RootCategory && a.Published == 1).ToList(); var allCategories = dataContext.Categories.Where(a => a.Published == 1).ToList(); return(rootCategories.Select(s => new RootCategoryModel { CategoryId = s.Id, CategoryDescription = s.Description ?? "", CategoryName = s.Name ?? "", DisplayOrder = s.Display_Order ?? 0, ParentCategoryId = s.ParentCategoryId ?? 0, PictureUrl = s.PictureUrl ?? "", RootCategoryId = s.RootCategory ?? 0, RootTree = s.TempPID ?? "", ChildCategories = allCategories.Where(a => a.RootCategory == s.Id).Select(s1 => s1.Id).ToList(), }).ToList()); } }
public bool AddNewCustomerPassword(Guid customerId, string password) { try { using (var dataContext = new BrownBagDataEntities()) { dataContext.CustomerPasswords.Add(new DataEntity.CustomerPassword { CustomerId = customerId, Password = password, PasswordFormatId = 1, CreatedOnUtc = DateTime.Now.ToUniversalTime(), }); return(dataContext.SaveChanges() > 0 ? true : false); } } catch { throw; } }
public bool UpdateOTP(OtpDetailsModel OtpDetailsModel) { try { using (var dataContext = new BrownBagDataEntities()) { var otp = dataContext.OtpDetails.Where(a => a.Id == OtpDetailsModel.Id).FirstOrDefault(); otp.ExpiryDate = OtpDetailsModel.ExpiryDate; otp.IsActive = OtpDetailsModel.IsActive; otp.IsVerified = OtpDetailsModel.IsVerified; otp.IssueDate = OtpDetailsModel.IssueDate; return(dataContext.SaveChanges() > 0 ? true : false); } } catch { throw; } }
public bool DeleteDeviceRegistration(string deviceId) { try { using (var dataContext = new BrownBagDataEntities()) { var selectedDevice = dataContext.DeviceRegistrations.Where(a => a.IMEI_Number == deviceId).FirstOrDefault(); if (selectedDevice != null) { dataContext.DeviceRegistrations.Remove(selectedDevice); return(dataContext.SaveChanges() > 0 ? true : false); } else { return(false); } } } catch { throw; } }