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;
}
