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