public bool checkLoginDetails(LoginModel loginDetails) { loginDetails.Password = hashPassword(loginDetails.Password); CustomerDal dalobj = new CustomerDal(); if(dalobj.LoginCheck(loginDetails)) return true; return false; }
public int checkAvailableQuantity(int apparelID, string apparelSize, int quantity) { CustomerDal custDal = new CustomerDal(); Quantity quantityDetails = custDal.GetQuantityDetailForApparel(Convert.ToInt32(apparelID), apparelSize); int availableQuantity = (quantityDetails.ApparelQuantity >= quantity) ? quantity : quantityDetails.ApparelQuantity; return availableQuantity; }
public DetailsViewModel GetCustomerDetails(string userID) { if (userID == string.Empty) { return null; } CustomerDal CustObj = new CustomerDal(); return CustObj.GetCustomerDetails(userID.ToString()); }
public bool sendRegisterDetails(Customer cust) { CustomerDal dalobj = new CustomerDal(); // step 1, calculate MD5 hash from input cust.Password = hashPassword(cust.Password); if(dalobj.AddCustomer(cust)) return true; return false; }
public string CheckAndUpdateCustomer(DetailsViewModel model,out int statusCode) { string status = ""; model.OldPassword = model.OldPassword ?? "" ; if (model.OldPassword != "" ) { model.OldPassword = hashPassword(model.OldPassword); model.Password = hashPassword(model.Password); } CustomerDal dalObj = new CustomerDal(); statusCode = 0; if (dalObj.CheckAndUpdateCustomer(model,out statusCode)) status = "Updated Successfully"; else status = HttpContext.Current.Session["ErrorMessage"].ToString(); return status; }
public CustomerBLL() { dalObj = new CustomerDal(); }
public List<CartItem> getUserCart(string UserID) { bool status = false; HttpContext.Current.Session["status"] = "DefaultMessage"; string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString; SqlConnection conn = new SqlConnection(conStr); List<CartItem> cartItems = new List<CartItem>(); try { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM SavedCart WHERE UserID=@UserID", conn); cmd.Parameters.AddWithValue("UserID", UserID.Trim()); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { CartItem cartItem = new CartItem(); string apparelID = reader.GetString(reader.GetOrdinal("ApparelID")); string apparelSize = reader.GetString(reader.GetOrdinal("ApparelSize")); string offerID = reader.GetString(reader.GetOrdinal("OfferID")); int quantity = reader.GetInt32(reader.GetOrdinal("Quantity")); cartItem.OfferID = offerID; cartItem.Apparel.ApparelSize = apparelSize; cartItem.Apparel.ApparelID = Convert.ToInt32(apparelID); CustomerDal custDal = new CustomerDal(); Quantity quantityDetails = custDal.GetQuantityDetailForApparel(Convert.ToInt32(apparelID), apparelSize); int availableQuantity = (quantityDetails.ApparelQuantity >= quantity) ? quantity : quantityDetails.ApparelQuantity; if(availableQuantity!=quantity) HttpContext.Current.Session["cartUpdated"] = "true"; if(availableQuantity >0 ) { cartItem.Quantity = availableQuantity; Apparel apparel = new Apparel(); apparel = custDal.GetApparelByID(Convert.ToInt32(apparelID))[0]; cartItem.Apparel.ApparelName = apparel.ApparelName; cartItem.Apparel.ApparelCost = quantityDetails.ApparelCost; cartItem.Apparel.ApparelDiscount = quantityDetails.ApparelDiscount; if(!(offerID.Trim().Equals("NOOFF"))) { AdminDal adminDal = new AdminDal(); Offer offer = new Offer(); offer = adminDal.GetOfferDateAndDiscountByID(offerID); if(System.DateTime.Equals(offer.OfferDate, DateTime.Now.Date)) cartItem.Apparel.ApparelDiscount += offer.Discount; } cartItems.Add(cartItem); } } } conn.Close(); conn.Open(); SqlCommand cmd2 = new SqlCommand("DELETE FROM SavedCart WHERE UserID=@UserID", conn); cmd2.Parameters.AddWithValue("UserID", UserID.Trim()); var reader2 = cmd2.ExecuteNonQuery(); } catch (Exception exc) { HttpContext.Current.Session["ErrorMessage"] = exc.Message; } conn.Close(); return cartItems; }
public ActionResult GetRatingDetails(string apparelID) { CustomerDal obj = new CustomerDal(); return(Json(obj.GetRatingDetails(apparelID),JsonRequestBehavior.AllowGet)); }
public ActionResult UpdateRatingDetails(string apparelID , string userID , int rating , string comment, int currRating) { CustomerDal obj = new CustomerDal(); bool status = obj.InsertOrUpdateRating(apparelID , userID , rating , comment,currRating); return(Json(new {state = status},JsonRequestBehavior.AllowGet)); }
public DetailsViewModel getShippingDetails(string customerID) { CustomerDal custDalObj = new CustomerDal(); return custDalObj.GetCustomerDetails(customerID); }