public bool DeleteProduct(int pid) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var size = context.SizeTable.Where(x => x.ProductID == pid).ToList(); var product = context.ProductTable.FirstOrDefault(x => x.ProductID == pid); var cart = context.CartTable.FirstOrDefault(x => x.PID == pid); if (size != null && product != null) { if (cart != null) { context.CartTable.Remove(cart); context.SaveChanges(); } foreach (var i in size) { context.SizeTable.Remove(i); } context.SaveChanges(); context.ProductTable.Remove(product); context.SaveChanges(); return(true); } else { return(false); } } }
public int OrderNow(int uid, int pid, OrderModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { UserTable user = new UserTable(); user = context.UserTable.FirstOrDefault(m => m.UserID == uid); SizeTable st = new SizeTable(); st = context.SizeTable.FirstOrDefault(m => m.PID == pid); if (st.productQuantity > 0) { OrderTable ot = new OrderTable() { UserID = uid, PID = pid, productBrand = st.ProductTable.productBrand, ProductName = st.ProductTable.productName, productPicture = st.ProductTable.picture1, productPrice = st.productPrice, productSize = st.productSize, productQuantity = 1 }; st.productQuantity -= 1; context.OrderTable.Add(ot); context.SaveChanges(); SizeTable seller = new SizeTable(); seller = context.SizeTable.FirstOrDefault(x => x.PID == pid); ProductTable pp = new ProductTable(); pp = context.ProductTable.FirstOrDefault(m => m.ProductID == seller.ProductID); SoldTable soldt = new SoldTable() { SellerID = pp.SellerID, productName = st.ProductTable.productName, productBrand = st.ProductTable.productBrand, productPrice = st.productPrice, productQuantity = 1, productSize = st.productSize, productPicture = st.ProductTable.picture1, PID = pid, UserName = user.email }; context.SoldTable.Add(soldt); context.SaveChanges(); return(1); } else { return(0); } } }
public HttpResponseMessage VerifyAccount([FromUri] string id) { //bool status = false; try { using (ShoppingELFEntities context = new ShoppingELFEntities()) { UserTable us = new UserTable(); var v = context.UserTable.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (v != null) { us.IsEmailVerified = true; v.IsEmailVerified = Convert.ToBoolean(us.IsEmailVerified); context.SaveChanges(); //status = true; return(Request.CreateResponse(HttpStatusCode.OK, "Your account has been successfully verified, Please go back on the login page to continue shopping with us<br/>Thank You!!!<br/>Team ShoppingELF")); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "Unable to activate account")); } } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ex)); } }
public IHttpActionResult ResetPassword(ChangePasswordModel model) { try { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var user = context.UserTable.Where(x => x.email == model.EmailID).FirstOrDefault(); if (user != null && Convert.ToBoolean(user.IsResetPassword)) { user.password = Crypto.Hash(model.NewPassword); user.ResetPasswordCode = ""; user.IsResetPassword = false; context.Configuration.ValidateOnSaveEnabled = false; context.SaveChanges(); return(Ok("New Password updated successfully")); } else { return(Ok("unable to reach account please try again")); } } } catch (Exception ex) { return(BadRequest()); } }
public IHttpActionResult ResetPassword(string ID) { try { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var user = context.UserTable.Where(x => x.ResetPasswordCode == ID).FirstOrDefault(); if (user != null) { ChangePasswordModel model = new ChangePasswordModel(); user.IsResetPassword = true; context.SaveChanges(); return(Ok("Account Verified")); } else { return(Ok("Something Went Wrong")); } } } catch (Exception ex) { return(BadRequest()); } }
public IHttpActionResult ForgotPassword(ChangePasswordModel model) { try { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var acc = context.UserTable.Where(x => x.email == model.EmailID).FirstOrDefault(); if (acc != null) { string ResetCode = Guid.NewGuid().ToString(); EmailVerification(acc.UserID, acc.email, ResetCode, "ResetPassword"); acc.ResetPasswordCode = ResetCode; context.Configuration.ValidateOnSaveEnabled = false; context.SaveChanges(); return(Ok("Reset password code has been sent to your email")); } else { return(Ok("Account Not found")); } } } catch (Exception ex) { return(BadRequest()); } }
public int ChangePassword(int uid, ChangePasswordModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var user = context.UserTable.FirstOrDefault(x => x.UserID == uid); if (user != null) { string oldPassword = Crypto.Hash(model.oldPassword); string newPassword = Crypto.Hash(model.NewPassword); if (oldPassword != user.password) { return(1); } else if (newPassword == user.password) { return(4); } else { user.password = newPassword; context.SaveChanges(); return(2); } //return 0; } else { return(3); } } }
public bool EnterDetails(int sid, SellerDetailsModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { SellerDetailsTable sdt = new SellerDetailsTable() { AddressLine1 = model.AddressLine1, AddressLine2 = model.AddressLine2, pincode = model.pincode, state = model.state, city = model.city, AccountHolderName = model.AccountHolderName, accountNumber = model.accountNumber, accountType = model.accountType, IFSCCode = model.IFSCCode, ShippingFee = model.ShippingFee, GSTNumber = model.GSTNumber, PANCardNumber = model.PANCardNumber, SellerID = sid }; context.SellerDetailsTable.Add(sdt); context.SaveChanges(); return(true); } }
public IHttpActionResult EnterOTP(int sid, SellerModel model) { try { using (ShoppingELFEntities context = new ShoppingELFEntities()) { SellerTable seller = new SellerTable(); seller = context.SellerTable.FirstOrDefault(m => m.SellerID == sid); bool x = new SellerAccountModel().IsOTPExpired(sid); if (seller.OTP == model.OTP && !x) { seller.IsAccountVerified = true; context.SaveChanges(); return(Ok(TokenManager.GenerateToken(seller.email))); } else { return(BadRequest("Please enter a valid OTP")); } } } catch (Exception ex) { return(BadRequest()); } }
public bool EditDetails(int sid, SellerDetailsModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { SellerDetailsTable sdt = new SellerDetailsTable(); sdt = context.SellerDetailsTable.FirstOrDefault(x => x.SellerID == sid); if (sdt != null) { sdt.AddressLine1 = model.AddressLine1; sdt.AddressLine2 = model.AddressLine2; sdt.pincode = model.pincode; sdt.state = model.state; sdt.city = model.city; sdt.AccountHolderName = model.AccountHolderName; sdt.accountNumber = model.accountNumber; sdt.accountType = model.accountType; sdt.ShippingFee = model.ShippingFee; sdt.GSTNumber = model.GSTNumber; sdt.PANCardNumber = model.PANCardNumber; context.SaveChanges(); return(true); } else { return(false); } } }
public void OTPSentTime(string Email) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { SellerTable st = new SellerTable(); st = context.SellerTable.FirstOrDefault(m => m.email == Email); st.OTPSentTIme = DateTime.Now.TimeOfDay.Minutes; context.SaveChanges(); } }
public int ImageUpload(int pid, int picimg, string imgpath) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { ProductTable pt = new ProductTable(); pt = context.ProductTable.FirstOrDefault(m => m.ProductID == pid); if (pt != null) { if (picimg == 1) { pt.picture1 = imgpath; context.SaveChanges(); return(1); } else if (picimg == 2) { pt.picture2 = imgpath; context.SaveChanges(); return(1); } else if (picimg == 3) { pt.picture3 = imgpath; context.SaveChanges(); return(1); } else if (picimg == 4) { pt.picture4 = imgpath; context.SaveChanges(); return(1); } else { return(0); } } else { return(2); } } }
public void ResendOTP(int sid) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { SellerTable st = new SellerTable(); st = context.SellerTable.FirstOrDefault(m => m.SellerID == sid); string otp = GenerateRandomNumber(); st.OTP = otp; st.OTPSentTIme = DateTime.Now.TimeOfDay.Minutes; context.SaveChanges(); } }
public void ClearCart(int uid) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var querry = context.CartTable.Where(m => m.UserID == uid).ToList(); foreach (var q in querry) { context.CartTable.Remove(q); } context.SaveChanges(); } }
public void AddSeller(SellerTable seller) { SellerTable st = new SellerTable(); using (ShoppingELFEntities db = new ShoppingELFEntities()) { seller.OTP = Convert.ToString(GenerateRandomNumber()); seller.Role = "Seller"; seller.password = Crypto.Hash(seller.password); db.SellerTable.Add(seller); db.SaveChanges(); } }
public void AddUser(UserTable user) { UserTable us = new UserTable(); using (ShoppingELFEntities db = new ShoppingELFEntities()) { us.ActivationCode = Guid.NewGuid(); user.ActivationCode = us.ActivationCode; user.Role = "User"; user.password = Crypto.Hash(user.password); db.UserTable.Add(user); db.SaveChanges(); } }
public bool DeleteSize(int pid) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var size = context.SizeTable.FirstOrDefault(x => x.PID == pid); if (size != null) { var order = context.CartTable.FirstOrDefault(x => x.PID == pid); if (order != null) { context.CartTable.Remove(order); context.SaveChanges(); } context.SizeTable.Remove(size); context.SaveChanges(); return(true); } else { return(false); } } }
public int AddToCart(int uid, int pid) { using (var context = new ShoppingELFEntities()) { CartTable ct = new CartTable() { PID = pid, UserID = uid, Quantity = 1 }; context.CartTable.Add(ct); context.SaveChanges(); return(ct.CartID); } }
public int RemoveFromCart(int cid) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var result = context.CartTable.FirstOrDefault(x => x.CartID == cid); if (result != null) { context.CartTable.Remove(result); context.SaveChanges(); return(1); } else { return(0); } } }
public bool AddProductSize(int pid, SizeModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { SizeTable st = new SizeTable() { ProductID = pid, productSize = model.productSize, productPrice = model.productPrice, productQuantity = model.productQuantity }; context.SizeTable.Add(st); context.SaveChanges(); SelectMininmumPrice(pid); } return(true); }
public bool UpdateCartModel(int cid, CartModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var cart = context.CartTable.FirstOrDefault(m => m.CartID == cid); if (cart != null) { cart.Quantity = model.Quantity; context.SaveChanges(); return(true); } else { return(false); } } }
public void AddAddress(int uid, AddressModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { AddressTable at = new AddressTable() { AddressLine1 = model.AddressLine1, AddressLine2 = model.AddressLine2, Pincode = model.Pincode, State = model.State, city = model.city, UserID = uid }; context.AddressTable.Add(at); context.SaveChanges(); } }
public bool EditAccount(int uid, UserModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var user = context.UserTable.FirstOrDefault(x => x.UserID == uid); if (user != null) { user.phoneNumber = model.phoneNumber; user.yourName = model.yourName; context.SaveChanges(); return(true); } else { return(false); } } }
public int AddProduct(int subid, int sid, int suitid, ProductModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { ProductTable pt = new ProductTable() { productName = model.productName, productBrand = model.productBrand, productDetails = model.productDetails, SubCategoryID = subid, SellerID = sid, SuitableID = suitid }; context.ProductTable.Add(pt); context.SaveChanges(); return(pt.ProductID); } }
public bool EditProduct(int pid, SizeModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var product = context.SizeTable.FirstOrDefault(x => x.PID == pid); if (product != null) { product.productPrice = model.productPrice; product.productQuantity = model.productQuantity; product.productSize = model.productSize; context.SaveChanges(); return(true); } else { return(false); } } }
public void SelectMininmumPrice(int pid) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { ProductTable pt = new ProductTable(); SizeTable st = new SizeTable(); pt = context.ProductTable.FirstOrDefault(x => x.ProductID == pid); var SizeList = context.SizeTable.Where(m => m.ProductID == pid).ToList(); int min_price = 2147483647; foreach (var i in SizeList) { if (i.productPrice < min_price) { min_price = i.productPrice; } } pt.price = min_price; context.SaveChanges(); } }
public bool EditAddress(int uid, AddressModel model) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { var Address = context.AddressTable.FirstOrDefault(x => x.UserID == uid); if (Address != null) { Address.AddressLine1 = model.AddressLine1; Address.AddressLine2 = model.AddressLine2; Address.city = model.city; Address.Pincode = model.Pincode; Address.State = model.State; context.SaveChanges(); return(true); } else { return(false); } } }
public int AddFromCartToOrder(int uid) { using (ShoppingELFEntities context = new ShoppingELFEntities()) { CartTable ct = new CartTable(); SizeTable st = new SizeTable(); UserTable user = new UserTable(); user = context.UserTable.FirstOrDefault(m => m.UserID == uid); var cart = context.CartTable.Where(m => m.UserID == uid).ToList(); var cartitems = context.CartTable.Where(m => m.UserID == uid).ToList(); if (cart.Count > 0) { foreach (var i in cartitems) { st = context.SizeTable.FirstOrDefault(x => x.PID == i.PID); if (st.productQuantity > 0) { OrderTable ot = new OrderTable() { UserID = uid, productBrand = i.SizeTable.ProductTable.productBrand, ProductName = i.SizeTable.ProductTable.productName, productPicture = i.SizeTable.ProductTable.picture1, productPrice = i.SizeTable.productPrice, productSize = i.SizeTable.productSize, productQuantity = i.Quantity, PID = i.PID, }; st.productQuantity -= i.Quantity; context.OrderTable.Add(ot); context.SaveChanges(); ProductTable seller = new ProductTable(); seller = context.ProductTable.FirstOrDefault(x => x.ProductID == i.SizeTable.ProductID); SoldTable soldt = new SoldTable() { SellerID = seller.SellerID, productName = i.SizeTable.ProductTable.productName, productBrand = i.SizeTable.ProductTable.productBrand, productPrice = i.SizeTable.productPrice, productQuantity = i.SizeTable.productQuantity, productSize = i.SizeTable.productSize, productPicture = i.SizeTable.ProductTable.picture1, PID = i.PID, UserName = user.email }; context.SoldTable.Add(soldt); context.SaveChanges(); //return 1; } else { return(2); } } return(3); } else { return(0); } } }