public bool AddOffer(Offer OfferObj) { bool status = false; string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString; if (HasOfferWithSameDate( OfferObj.OfferDate )) { HttpContext.Current.Session["ErrorMessage"] = "Offer with Same Date exists"; return status; } SqlConnection conn = new SqlConnection(conStr); try { conn.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO Offer VALUES (@name, @desc, @date, @appid, @discount) ", conn); cmd.Parameters.AddWithValue("name", OfferObj.OfferName.Trim()); cmd.Parameters.AddWithValue("desc", OfferObj.OfferDescription); cmd.Parameters.AddWithValue("date", OfferObj.OfferDate); cmd.Parameters.AddWithValue("appid", OfferObj.ApparelID); cmd.Parameters.AddWithValue("discount", OfferObj.Discount); int i = (Int32)cmd.ExecuteNonQuery(); if (i > 0) status = true; } catch (Exception ExcObj) { HttpContext.Current.Session["ErrorMessage"] = ExcObj.Message; } conn.Close(); return status; }
public bool addOffer(Offer model) { AdminDal obj = new AdminDal(); if (obj.AddOffer(model)) return true; return false; }
public Offer GetOfferDetails(string date) { Offer obj = new Offer(); string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString; SqlConnection conn = new SqlConnection(conStr); try { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * from Offer where OfferDate=@offdate", conn); cmd.Parameters.AddWithValue("offdate", date); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { //Offer obj = new Offer(); obj.OfferName = reader.GetString(reader.GetOrdinal("OfferName")); obj.ApparelID = reader.GetInt32(reader.GetOrdinal("OfferApparelID")); obj.OfferDescription = reader.GetString(reader.GetOrdinal("OfferDescription")); obj.Discount = reader.GetDecimal(reader.GetOrdinal("OfferDiscount")); obj.OfferDate = reader.GetDateTime(reader.GetOrdinal("OfferDate")).Date; //objlist.Add(obj); } } conn.Close(); } catch (Exception ExcObj) { HttpContext.Current.Session["ErrorMessage"] = ExcObj.Message; } conn.Close(); return obj; }
public Offer GetOfferDateAndDiscountByID(string offerID) { Offer offer = new Offer(); string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString; SqlConnection conn = new SqlConnection(conStr); try { conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * from Offer where OfferID=@offerID", conn); cmd.Parameters.AddWithValue("offerID", offerID); var reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { //Offer obj = new Offer(); offer.Discount = reader.GetDecimal(reader.GetOrdinal("OfferDiscount")); offer.OfferDate = reader.GetDateTime(reader.GetOrdinal("OfferDate")).Date; } } conn.Close(); } catch (Exception ExcObj) { HttpContext.Current.Session["ErrorMessage"] = ExcObj.Message; } conn.Close(); return offer; }
public ActionResult Offer(Offer model) { AdminBLL obj = new AdminBLL(); List<SelectListItem> defaultList = new List<SelectListItem>(); defaultList = UtilityFunctions.getCategoryDropDown(); // defaultList[0].Selected= false; // defaultList[Convert.ToInt32(ModelState["temp"])].Selected = true; ViewBag.categoryData = defaultList; if (obj.addOffer(model)) { ViewBag.Message = "Offer Added Successfully"; Session["OfferMessage"] = "false"; } else { if (Convert.ToString(Session["ErrorMessage"]) == "Offer with Same Date exists") { Session["OfferMessage"] = "true"; Session["ErrorMessage"] = "Offer with Same Date Exists. Try Updating the Offer!"; ViewBag.Message = ""; } else { Session["OfferMessage"] = "true"; Session["ErrorMessage"] = "Unable to add Offer"; } } return View(model); ; }
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; }