public Apparel getApparelForCart(string apparelID, string size)
{
Apparel data = new Apparel();
string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select ap.ApparelID, ap.ApparelName, qt.ApparelSize, qt.ApparelDiscount, qt.ApparelCost from Apparel ap INNER JOIN Quantity qt ON ap.ApparelID=qt.ApparelID where ap.ApparelID=@apparelID AND qt.ApparelSize=@size", conn);
cmd.Parameters.AddWithValue("apparelID", apparelID.Trim());
cmd.Parameters.AddWithValue("size", size.Trim());
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
data.ApparelName = reader.GetString(reader.GetOrdinal("ApparelName"));
data.ApparelID = reader.GetInt32(reader.GetOrdinal("ApparelID"));
data.ApparelCost = reader.GetDecimal(reader.GetOrdinal("ApparelCost"));
data.ApparelSize = reader.GetString(reader.GetOrdinal("ApparelSize")).Trim();
data.ApparelDiscount = reader.GetDecimal(reader.GetOrdinal("ApparelDiscount"));
}
}
}
catch (Exception ExcObj)
{
HttpContext.Current.Session["ErrorMessage"] = ExcObj.Message;
}
conn.Close();
return data;
}
public List<Apparel> GetProductByCategory(string category)
{
List<Apparel> dataRows = new List<Apparel>();
string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select * from Apparel ap INNER JOIN Quantity qt ON ap.ApparelID=qt.ApparelID where ApparelCategory=@category order by ap.ApparelAddTime desc", conn);
cmd.Parameters.AddWithValue("category", category.Trim());
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Apparel prodObj = new Apparel();
prodObj.ApparelID = reader.GetInt32(reader.GetOrdinal("ApparelID"));
prodObj.ApparelName = reader.GetString(reader.GetOrdinal("ApparelName"));
prodObj.BrandName = reader.GetString(reader.GetOrdinal("BrandName"));
prodObj.ApparelCost = reader.GetDecimal(reader.GetOrdinal("ApparelCost"));
prodObj.Description = reader.GetString(reader.GetOrdinal("Description"));
prodObj.ApparelImage = reader.GetString(reader.GetOrdinal("ApparelImage"));
prodObj.ApparelCategory = reader.GetString(reader.GetOrdinal("ApparelCategory"));
prodObj.ApparelRating = reader.GetInt32(reader.GetOrdinal("ApparelRating"));
prodObj.ApparelSize = reader.GetString(reader.GetOrdinal("ApparelSize"));
prodObj.ApparelDiscount = reader.GetDecimal(reader.GetOrdinal("ApparelDiscount"));
dataRows.Add(prodObj);
}
}
}
catch (Exception ExcObj)
{
HttpContext.Current.Session["ErrorMessage"] = ExcObj.Message;
}
conn.Close();
return dataRows;
}
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 CartItem(Apparel apparel, int quantity, string offerID)
{
this.apparel = apparel;
this.quantity = quantity;
this.OfferID = offerID;
}
public List<Apparel> GetApparelByID(int id)
{
List<Apparel> dataRows = new List<Apparel>();
string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select * from Apparel where ApparelID=@id", conn);
cmd.Parameters.AddWithValue("id", id);
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Apparel prodObj = new Apparel();
prodObj.ApparelID = reader.GetInt32(reader.GetOrdinal("ApparelID"));
prodObj.ApparelName = reader.GetString(reader.GetOrdinal("ApparelName"));
prodObj.BrandName = reader.GetString(reader.GetOrdinal("BrandName"));
prodObj.Description = reader.GetString(reader.GetOrdinal("Description"));
prodObj.ApparelImage = reader.GetString(reader.GetOrdinal("ApparelImage"));
prodObj.ApparelCategory = reader.GetString(reader.GetOrdinal("ApparelCategory"));
prodObj.ApparelRating = reader.GetInt32(reader.GetOrdinal("ApparelRating"));
dataRows.Add(prodObj);
}
}
}
catch (Exception ExcObj)
{
HttpContext.Current.Session["ErrorMessage"] = ExcObj.Message;
}
conn.Close();
return dataRows;
}
public AddApparel()
{
apparel = new Apparel();
}
public ActionResult OfferOfDay()
{
ViewBag.Title = "Offer of The Day!!!";
CustomerBLL obj = new CustomerBLL();
List<Offer> model = new List<Offer>();
model = obj.GetTodaysOffer();
Apparel apparel = new Apparel();
if (model.Count > 0)
{
apparel = obj.GetApparelByID(model[0].ApparelID)[0];
ViewBag.OfferID = model[0].OfferID;
ViewBag.OfferName = model[0].OfferName;
ViewBag.OfferDescription = model[0].OfferDescription;
ViewBag.OfferDiscount = model[0].Discount;
ViewBag.OfferName = model[0].OfferName;
}
else
{
ViewBag.OfferTitle = "none";
}
return View(apparel);
}
public ActionResult OrderNowOffer(string id, string size, string offerDiscount, string offerID)
{
size = size.Trim();
if (Session["UserID"] == null)
return RedirectToAction("Login", "Account");
if (Session["UserRole"].ToString() == "admin")
return RedirectToAction("Index", "Admin");
Apparel apparel = new Apparel();
apparel = bllObj.getApparelForCart(id, size);
apparel.ApparelDiscount += Convert.ToDecimal(offerDiscount);
if (Session["cart"] == null)
{
List<CartItem> cart = new List<CartItem>();
cart.Add(new CartItem(apparel, 1, offerID));
Session["cart"] = cart;
}
else
{
List<CartItem> cart = (List<CartItem>)Session["cart"];
int index = IsExisting(Convert.ToInt32(id), size);
if (index == -1)
cart.Add(new CartItem(apparel, 1, offerID));
else
cart[index].Quantity++;
Session["cart"] = cart;
}
return RedirectToAction("Index");
}
