public ActionResult SaveDeletedProduct(Models.Product pr)
{
if (ModelState.IsValid)
{
try
{
QuickKartRepository rep = new QuickKartRepository();
MyMapper <Models.Product, Product> mapObj = new MyMapper <Models.Product, Product>();
bool status = rep.DeleteProduct(mapObj.Translate(pr));
if (status)
{
return(RedirectToAction("ViewProducts"));
}
else
{
return(View("Error"));
}
}
catch (Exception ex)
{
return(View("Error"));
}
}
return(View("DeleteProduct", pr));
}
public List <Common.Models.PurchaseDetail> GetPurchaseDetailsByEmailId(string emailId)
{
try
{
var dal = new QuickKartRepository();
var purchaseList = dal.DisplayPurchaseDetailsByCustomer(emailId);
var purchases = new List <Common.Models.PurchaseDetail>();
if (purchaseList.Any())
{
foreach (var purchase in purchaseList)
{
var purchaseObj = new Common.Models.PurchaseDetail();
purchaseObj.PurchaseId = purchase.PurchaseId;
purchaseObj.EmailId = purchase.EmailId;
purchaseObj.ProductId = purchase.ProductId;
purchaseObj.ProductName = purchase.Product.ProductName;
purchaseObj.QuantityPurchased = purchase.QuantityPurchased;
purchaseObj.PurchaseDate = purchase.DateOfPurchase.ToShortDateString();
purchases.Add(purchaseObj);
}
}
return(purchases);
}
catch (Exception ex)
{
return(null);
}
}
public List <Common.Models.CartProductsDetails> GetCartProducts(string emailId)
{
try
{
var dal = new QuickKartRepository();
var cartProductList = dal.DisplayCartProductDetails(emailId);
Common.Models.CartProductsDetails product;
var cartProducts = new List <Common.Models.CartProductsDetails>();
if (cartProductList.Any())
{
foreach (var prod in cartProductList)
{
product = new Common.Models.CartProductsDetails();
product.ProductId = prod.ProductId;
product.ProductName = prod.ProductName;
product.Quantity = prod.Quantity;
product.QuantityAvailable = prod.QuantityAvailable;
product.Price = prod.Price;
cartProducts.Add(product);
}
}
return(cartProducts);
}
catch (Exception)
{
return(null);
}
}
public ActionResult SaveAddedProduct(Models.Product prodObj)
{
if (ModelState.IsValid)
{
try
{
QuickKartRepository repobj = new QuickKartRepository();
MyMapper <Models.Product, Product> mapObj = new MyMapper <Models.Product, Product>();
var status = repobj.AddProduct(mapObj.Translate(prodObj));
if (status)
{
return(RedirectToAction("ViewProducts"));
}
else
{
return(View("Error"));
}
}
catch (Exception)
{
return(View("Error"));
}
}
return(View("AddProduct", prodObj));
}
public List <Common.Models.Rating> DisplayAllReviewDetailsByCustomer(string emailId)
{
try
{
var dal = new QuickKartRepository();
var ratingList = dal.DisplayAllReviewDetailsByCustomer(emailId);
Common.Models.Rating rating;
var ratings = new List <Common.Models.Rating>();
if (ratingList.Any())
{
foreach (var rate in ratingList)
{
rating = new Common.Models.Rating();
rating.EmailId = rate.EmailId;
rating.ProductId = rate.ProductId;
rating.ProductName = rate.Product.ProductName;
rating.ReviewComments = rate.ReviewComments;
rating.ReviewRating = rate.ReviewRating;
ratings.Add(rating);
}
}
return(ratings);
}
catch (Exception ex)
{
return(null);
}
}
public ActionResult GetProductForCategory(byte?categoryId)
{
QuickKartRepository repObj = new QuickKartRepository();
ViewBag.CategoryList = repObj.GetCategoriesUsinglinq();
if (categoryId != null)
{
Session["categoryId"] = categoryId;
}
else
{
categoryId = Convert.ToByte(Session["categoryId"]);
}
ViewBag.SelectedCategory = repObj.GetCategoriesUsinglinq().Where(x => x.CategoryId == categoryId).Select(x => x.CategoryName).FirstOrDefault();
if (ViewBag.SelectedCategory == null)
{
ViewBag.SelectedCategory = "--Select--";
}
var productList = repObj.GetProductUsingLinq();
var mapObj = new MyMapper <Product, Models.Product>();
var products = new List <Models.Product>();
foreach (var product in productList)
{
products.Add(mapObj.Translate(product));
}
var filteredProducts = products.Where(model => model.CategoryId == categoryId);
return(View(filteredProducts));
}
public List <Common.Models.Product> GetProducts()
{
try
{
var dal = new QuickKartRepository();
var productList = dal.DisplayProductDetails();
var products = new List <Common.Models.Product>();
if (productList.Any())
{
foreach (var prod in productList)
{
var product = new Common.Models.Product();
product.ProductId = prod.ProductId;
product.ProductName = prod.ProductName;
product.CategoryId = prod.CategoryId;
product.Price = prod.Price;
product.QuantityAvailable = prod.QuantityAvailable;
products.Add(product);
}
}
return(products);
}
catch (Exception)
{
return(null);
}
}
public CategoryController()
{
rep = new QuickKartRepository();
mCategory = new List <Models.Category>();
mapObj = new MyMapper <Category, Models.Category>();
mapMod = new MyMapper <Models.Category, Category>();
category = new List <Category>();
}
public ActionResult AddProduct()
{
QuickKartRepository repobj = new QuickKartRepository();
string productId = repobj.GetNewProductIdUsingUFN();
ViewBag.NextProductId = productId;
return(View());
}
// GET: Product
public ActionResult ViewProducts()
{
QuickKartRepository rep = new QuickKartRepository();
List <Product> prodList = rep.GetProductUsingLinq();
List <Models.Product> mProdtList = new List <Models.Product>();
MyMapper <Product, Models.Product> mapObj = new MyMapper <Product, Models.Product>();
foreach (var item in prodList)
{
mProdtList.Add(mapObj.Translate(item));
}
return(View(mProdtList));
}
public int AddProductToCart(Common.Models.Cart cartObj)
{
int returnvalue = -1;
try
{
var dal = new QuickKartRepository();
returnvalue = dal.AddProductToCartUsingUSP(cartObj.ProductId, cartObj.EmailId);
}
catch (Exception)
{
returnvalue = -1;
}
return(returnvalue);
}
public bool DeleteCartProduct(Common.Models.Cart cartObj)
{
var status = false;
try
{
var dal = new QuickKartRepository();
status = dal.DeleteCartProduct(cartObj.ProductId, cartObj.EmailId);
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public bool DeleteRating(Common.Models.Rating rating)
{
var status = false;
try
{
var dal = new QuickKartRepository();
status = dal.DeleteRating(rating.EmailId, rating.ProductId);
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public bool InsertRating(Common.Models.Rating rating)
{
bool status = false;
try
{
var dal = new QuickKartRepository();
status = dal.AddRatings(rating);
}
catch (Exception)
{
status = false;
}
return(status);
}
public bool UpdateReviewComments(Common.Models.Rating rating)
{
bool status = false;
try
{
var dal = new QuickKartRepository();
status = dal.UpdateReviewComments(rating.EmailId, rating.ProductId, rating.ReviewComments);
}
catch (Exception)
{
status = false;
}
return(status);
}
public string ValidateUserCredentials(string emailId, string password)
{
string roleName = "";
try
{
var dal = new QuickKartRepository();
roleName = dal.ValidateLoginUsingLinq(emailId, password);
}
catch (Exception)
{
roleName = "Invalid credentials";
}
return(roleName);
}
public bool UpdateCartProducts(Common.Models.Cart cartObj)
{
bool status = false;
try
{
var dal = new QuickKartRepository();
status = dal.UpdateCartProductsLinq(cartObj.ProductId, cartObj.EmailId, cartObj.Quantity);
}
catch (Exception)
{
status = false;
}
return(status);
}
public JsonResult <Models.Product> GetProduct(string id)
{
try
{
var mapObj = new QuickKartMapper <Product, Models.Product>();
var dal = new QuickKartRepository();
Product productList = dal.GetProductUsingLinq().Where(x => x.ProductId == id).FirstOrDefault();
return(Json <Models.Product> (mapObj.Translate(productList)));
}
catch (Exception ex)
{
return(null);
}
}
public ActionResult CheckRole(FormCollection frm)
{
QuickKartRepository repObj = new QuickKartRepository();
string userId = frm["name"];
string password = frm["pwd"];
string checkBox = frm["Rememberme"];
byte? roleId = repObj.GetRoleIdByUserId(userId);
if (checkBox != "false")
{
HttpCookie cookieObj = new HttpCookie("User");
cookieObj.Values.Add("User", userId);
cookieObj.Values.Add("Password", password);
cookieObj.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookieObj);
}
if (repObj.ValidateCredentials(userId, password))
{
string lastLogin = null;
HttpCookie loginInCookie = new HttpCookie(userId);
if (Request.Cookies[userId] != null)
{
loginInCookie = Request.Cookies[userId];
TempData["lastLogin"] = loginInCookie.Values["lastLogin"];
}
loginInCookie["lastLogin"] = DateTime.Now.ToString();
loginInCookie.Expires = DateTime.MaxValue;
Response.Cookies.Add(loginInCookie);
if (roleId == 1)
{
Session["UserId"] = userId;
return(RedirectToAction("AdminHome", "Admin"));
}
else if (roleId == 2)
{
return(Redirect("/Customer/CustomerHome?user="******"Login"));
}
public Common.Models.Rating GetProductReviewByCustomer(string emailId, string productId)
{
var rating = new Common.Models.Rating();
try
{
var dal = new QuickKartRepository();
var rate = dal.GetProductReviewByCustomer(emailId, productId);
rating.EmailId = rate.EmailId;
rating.ProductId = rate.ProductId;
rating.ReviewRating = rate.ReviewRating;
rating.ReviewComments = rate.ReviewComments;
}
catch (Exception ex)
{
rating = null;
}
return(rating);
}
static void Main(string[] args)
{
//QuickKartRepository repository = new QuickKartRepository();
//byte categoryId = 1;
//List<Products> lstproducts = repository.GetProductsOnCategoryId(categoryId);
//if (lstproducts.Count == 0)
//{
// Console.WriteLine("No products available under the category = " + categoryId);
//}
//else
//{
// Console.WriteLine("{0,-15}{1,-30}{2,-15}{3,-10}{4}", "ProductId", "ProductName", "CategoryId", "Price", "QuantityAvailable");
// Console.WriteLine("---------------------------------------------------------------------------------------");
// foreach (var product in lstproducts)
// {
// Console.WriteLine("{0,-15}{1,-30}{2,-15}{3,-10}{4}", product.ProductId, product.ProductName, product.CategoryId, product.Price, product.QuantityAvailable);
// }
//}
//QuickKartRepository repository = new QuickKartRepository();
//bool result = repository.AddCategory("Books");
//if (result)
//{
// Console.WriteLine("New category added successfully");
//}
//else
//{
// Console.WriteLine("Something went wrong. Try again!");
//}
QuickKartRepository repository = new QuickKartRepository();
bool result = repository.UpdateCategory(11, "Stationery");
if (result)
{
Console.WriteLine("Category details updated successfully");
}
else
{
Console.WriteLine("Something went wrong. Try again!");
}
}
public JsonResult <List <Models.Product> > GetProducts()
{
try
{
var mapObj = new QuickKartMapper <Product, Models.Product>();
var dal = new QuickKartRepository();
var productList = dal.GetProductUsingLinq();
var products = new List <Models.Product>();
if (productList.Any())
{
foreach (var product in productList)
{
products.Add(mapObj.Translate(product));
}
}
return(Json <List <Models.Product> >(products));
}
catch (Exception ex)
{
return(null);
}
}
public bool RegisterUserUsingAPI(Common.Models.User user)
{
bool status;
try
{
DataAccessLayer.User userObj = new DataAccessLayer.User();
userObj.EmailId = user.EmailId;
userObj.UserPassword = user.UserPassword;
userObj.Gender = user.Gender;
userObj.DateOfBirth = user.DateOfBirth;
userObj.Address = user.Address;
var dal = new QuickKartRepository();
status = dal.RegisterUserUsingLinq(userObj);
}
catch (Exception)
{
status = false;
}
return(status);
}
public List <Common.Models.Category> GetCategories()
{
try
{
var dal = new QuickKartRepository();
var categoryList = dal.GetCategoriesUsingLinq();
var categories = new List <Common.Models.Category>();
if (categoryList.Any())
{
foreach (var cat in categoryList)
{
var category = new Common.Models.Category();
category.CategoryId = cat.CategoryId;
category.CategoryName = cat.CategoryName;
categories.Add(category);
}
}
return(categories);
}
catch (Exception ex)
{
return(null);
}
}
public ProductController(QuickKartRepository repObj, IMapper mapper)
{
_repObj = repObj;
_mapper = mapper;
}
public UserController(QuickKartRepository repObj)
{
_repObj = repObj;
}
public CategoryController(QuickKartRepository repository, IMapper mapper)
{
_repository = repository;
_mapper = mapper;
}
public UserController(QuickKartContext context)
{
_context = context;
repObj = new QuickKartRepository(_context);
}
public PurchaseController(QuickKartContext context, IMapper mapper)
{
_context = context;
repObj = new QuickKartRepository(_context);
_mapper = mapper;
}
public CategoriesController(QuickKartRepository repObj, IMapper mapper)
{
_repObj = repObj;
_mapper = mapper;
}
