public bool addOffer(Offer model)
{
AdminDal obj = new AdminDal();
if (obj.AddOffer(model))
return true;
return false;
}
public List<AddApparel> GetApparelsByBrandAndName(string name, string brand)
{
AdminDal obj = new AdminDal();
List<AddApparel> result = new List<AddApparel>();
result = obj.GetApparelsByBrandAndName(name, brand);
return result;
}
public List<Apparel> fetchProductByCategory(string category)
{
string cat = UtilityFunctions.parseInputCategoryToDBFormat(category);
AdminDal obj = new AdminDal();
List<Apparel> result = new List<Apparel>();
result = obj.GetProductByCategory(cat);
return result;
}
public List<DropDownFormat> GetApparelNameByBrand(string brand)
{
AdminDal obj = new AdminDal();
List<string> result = new List<string>();
List<DropDownFormat> res = new List<DropDownFormat>();
result = obj.GetApparelNameByBrand(brand.Trim());
foreach (var item in result)
{
res.Add(new DropDownFormat(){ name=item, value=item });
}
return res;
}
public bool addApparel(AddApparel model, out string AppID)
{
AdminDal obj = new AdminDal();
model.apparel.ApparelCategory = UtilityFunctions.parseInputCategoryToDBFormat(model.apparel.ApparelCategory);
model.apparel.ApparelImage = "/"+AdminController.ImagePath;
string fullPath = HttpContext.Current.Server.MapPath("~/") + AdminController.ImagePath;
if (model.apparel.ApparelImage == null)
model.apparel.ApparelImage = string.Empty;
if (obj.AddProduct(model, out AppID))
{
System.IO.File.Move( fullPath+"TempImage.jpg", fullPath + AppID + ".jpg");
return true;
}
return false;
}
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 List<DropDownFormat> GetBrandNames()
{
AdminDal obj = new AdminDal();
List<string> result = new List<string>();
List<DropDownFormat> res = new List<DropDownFormat>();
result = obj.GetBrandNames();
foreach (var item in result)
{
res.Add(new DropDownFormat(){ name=item, value=item });
}
return res;
}
public Offer fetchOfferByDate(string dateToProcess)
{
AdminDal obj = new AdminDal();
string dateFormatted = UtilityFunctions.parseInputDateToDBFormat(dateToProcess);
return obj.GetOfferDetails(dateFormatted);
}
public bool DeleteOffer(string offerDate)
{
AdminDal obj = new AdminDal();
return obj.DeleteOfferByDate(UtilityFunctions.parseInputDateToDBFormat(offerDate));
}
public bool UpdateOffer(string offerDate, string offerName, string offerDescription, string offerDiscount)
{
AdminDal obj = new AdminDal();
return obj.UpdateOfferByDate(UtilityFunctions.parseInputDateToDBFormat(offerDate), offerName, offerDescription, offerDiscount);
}
public bool UpdateApparel(string apparelID, string cost, string discount, string quantity, string category, string size)
{
AdminDal obj = new AdminDal();
return obj.UpdateApparel(Convert.ToInt32(apparelID), Convert.ToDecimal(cost), Convert.ToDecimal(discount), Convert.ToInt32(quantity), category, size);
}
