public IGernalResult getItem(int id)
{
IGernalResult result = new GernalResult();
try
{
ItemDto item = new ItemDto();
item = _dbContext.TblItem.Select(s => new ItemDto
{
Name = s.Name,
CatogeryId = s.CategoryId ?? 0,
Discription = s.Discription,
Id = s.Id,
//ImageUrl = _dbContext.TblItemImage.Where(w => w.ItemId == id).Select(s => s.ImageUrl).ToList(),
Image = s.ImageUrl,
ItemId = s.ItemId,
Price = s.Price,
Quantity = s.Quantity,
SellerId = Convert.ToString(s.SellerId),
}).Where(w => w.Id == id).FirstOrDefault();
result.Succsefully = true;
result.value = item;
}
catch
{
result.Succsefully = false;
result.Message = "Server error";
}
return(result);
}
public IGernalResult AddItem(ItemDto s)
{
IGernalResult result = new GernalResult();
try
{
TblItem item = new TblItem
{
Name = s.Name,
CategoryId = s.CatogeryId,
Discription = s.Discription,
ImageUrl = s.Image,
Price = s.Price,
Quantity = s.Quantity,
SellerId = Convert.ToInt32(s.SellerId),
CreatedDate = DateTime.UtcNow,
IsAvailable = true,
IsDelete = false
};
_dbContext.Add(item);
int save = _dbContext.SaveChanges();
result.Succsefully = save > 0 ? true : false;
result.Message = save > 0 ? "Selling Item add Succsefully" : "Selling Item not register";
}
catch (Exception ex)
{
result.Succsefully = false;
result.Message = "Server error";
}
return(result);
}
public IGernalResult UserRegistration(UserDto dto)
{
IGernalResult result = new GernalResult();
try
{
TblUser User = new TblUser
{
Name = dto.Name,
Address = dto.Address,
Email = dto.Email,
Password = dto.Password,
ImageUrl = dto.ImageUrl,
RoleId = dto.RoleId,
MobileNo = dto.MobileNo,
CreatedDate = DateTime.UtcNow,
IsSeller = dto.RoleId > 1 ? true : false
};
string userType = dto.RoleId > 1 ? "Seller" : "User";
_dbContext.Add(User);
int save = _dbContext.SaveChanges();
result.Succsefully = save > 0 ? true : false;
result.Message = save > 0 ? userType + " register Succsefully" : userType + "not register";
}
catch
{
result.Succsefully = false;
result.Message = "server error";
}
return(result);
}
public JsonResult RemoveTocart(int cartId)
{
IGernalResult result = new GernalResult();
try
{
if (cartId > 0)
{
var userId = HttpContext.Request.Cookies["user_id"];
var data = _IItem.RemoveFromCart(cartId, Convert.ToInt32(userId));
result.Message = data ? "Item removed from cart" : "item does not remove from cart";
result.Succsefully = data ? true : false;
}
else
{
result.Message = "please send valid cart id ";
result.Succsefully = false;
}
}
catch
{
result.Succsefully = false;
result.Message = "Server error.";
}
return(Json(result));
}
public JsonResult EditCart(int cartId, int quantity)
{
IGernalResult result = new GernalResult();
result = _IItem.EditFromCart(cartId, quantity);
return(Json(result));
}
public List <ItemDto> getAllItem()
{
List <ItemDto> items = new List <ItemDto>();
IGernalResult result = new GernalResult();
try
{
items = _dbContext.TblItem.Select(s => new ItemDto
{
Name = s.Name,
CatogeryId = s.CategoryId ?? 0,
Discription = s.Discription,
Id = s.Id,
// ImageUrl = _dbContext.TblItemImage.Where(w => w.ItemId == s.Id).Select(s => s.ImageUrl).ToList(),
Image = s.ImageUrl,
Price = s.Price,
Quantity = s.Quantity,
SellerId = Convert.ToString(s.SellerId),
SellerName = _dbContext.TblUser.Where(w => w.Id == s.SellerId).Select(s => s.Name).FirstOrDefault(),
}).ToList();
result.Succsefully = true;
result.value = items;
result.Message = Convert.ToString(items.Count);
}
catch
{
result.Succsefully = false;
result.Message = "Server error";
}
return(items);
}
public IGernalResult EditUser(UserDto dto)
{
IGernalResult result = new GernalResult();
try
{
TblUser User = _dbContext.TblUser.Where(w => w.Id == dto.Id).FirstOrDefault();
{
User.Name = dto.Name;
User.Address = dto.Address;
User.ImageUrl = dto.ImageUrl;
};
int save = _dbContext.SaveChanges();
result.Succsefully = save > 0 ? true : false;
result.Message = save > 0 ? "User update Succsefully" : "User not update";
}
catch
{
result.Succsefully = false;
result.Message = "server error";
}
return(result);
}
public IGernalResult AddOrder(OrderDto dto)
{
IGernalResult result = new GernalResult();
try
{
int totalplaceOrderquantiy = 0;
TblItem Item = _dbContext.TblItem.Where(w => w.Id == dto.ItemId).FirstOrDefault();
List <TblOrder> order = _dbContext.TblOrder.Where(w => w.ItemId == dto.ItemId && w.IsCanceled == false).ToList();
if (order != null)
{
foreach (var item in order)
{
int v = item.Quantity + totalplaceOrderquantiy;
totalplaceOrderquantiy = v;
}
}
int avilableNow = Convert.ToInt32(Item.Quantity) - totalplaceOrderquantiy;
if (totalplaceOrderquantiy == Convert.ToInt32(Item.Quantity))
{
result.Succsefully = false;
result.Message = "Item not availablenow plz try some time later.";
}
else if (avilableNow < dto.Quantity)
{
result.Succsefully = false;
result.Message = "Now we have avilable only" + avilableNow;
}
else
{
TblOrder Order = new TblOrder
{
IsCanceled = false,
OrderDate = DateTime.UtcNow,
UserId = dto.UserId,
ItemId = dto.ItemId,
PricePerItem = Convert.ToInt32(Item.Price),
PriceTotal = Convert.ToInt32(Item.Price) * dto.Quantity,
};
_dbContext.Add(Order);
int save = _dbContext.SaveChanges();
result.Message = save > 0 ? "Order add Succsefully" : "Order not add";
result.Succsefully = save > 0 ? true : false;
}
}
catch
{
result.Message = "server error";
result.Succsefully = false;
}
return(result);
}
public IActionResult Login(UserLoginModel model)
{
IGernalResult result = new GernalResult();
if (ModelState.IsValid)
{
try
{
result = _iAccount.userLogin(new UserDto
{
Email = model.Email,
Password = model.Password,
});
if (result.Succsefully)
{
var data = result.value as UserDto;
var userClaims = new List <Claim>()
{
new Claim(ClaimTypes.Email, data.Email),
new Claim(ClaimTypes.Role, data.Role),
new Claim(ClaimTypes.PrimarySid, data.Id.ToString())
};
HttpContext.Response.Cookies.Append("user_id", Convert.ToString(data.Id));
HttpContext.Response.Cookies.Append("Email", data.Email);
HttpContext.Response.Cookies.Append("Role", data.Role);
var userIdentity = new ClaimsIdentity(userClaims, "User Identity");
var userPrincipal = new ClaimsPrincipal(new[] { userIdentity });
HttpContext.SignInAsync(userPrincipal);
if (data.Role == "Custumer")
{
return(RedirectToAction("Index", "Home"));
}
if (data.Role == "Seller")
{
return(RedirectToAction("Index", "Seller"));
}
}
else
{
ViewBag.message = result.Message;
return(View());
}
}
catch (Exception ex)
{
throw;
}
}
return(View());
}
public IGernalResult EditFromCart(int cartId, int Countity)
{
IGernalResult result = new GernalResult();
TblCart cart = _dbContext.TblCart.Where(w => w.Id == cartId).FirstOrDefault();
try
{
int totalplaceOrderquantiy = 0;
TblItem Item = _dbContext.TblItem.Where(w => w.Id == cart.ItemId).FirstOrDefault();
List <TblOrder> order = _dbContext.TblOrder.Where(w => w.ItemId == cart.ItemId && w.IsCanceled == false).ToList();
if (order != null)
{
foreach (var item in order)
{
int v = item.Quantity + totalplaceOrderquantiy;
totalplaceOrderquantiy = v;
}
}
int avilableNow = Convert.ToInt32(Item.Quantity) - totalplaceOrderquantiy;
if (totalplaceOrderquantiy == Convert.ToInt32(Item.Quantity))
{
result.Succsefully = false;
result.Message = "Item not availablenow plz try some time later.";
}
else if (avilableNow < Countity)
{
result.Succsefully = false;
result.Message = "Now we have avilable only" + avilableNow;
}
else
{
int total = Convert.ToInt32(cart.PricePerItem) * Countity;
cart.TotalPrice = Convert.ToString(total);
cart.Quantity = Countity;
int save = _dbContext.SaveChanges();
result.Succsefully = save > 0 ? true : false;
}
}
catch
{
result.Succsefully = false;
result.Message = "server error.";
}
return(result);
}
public IActionResult UserAccountRegistration()
{
IGernalResult result = new GernalResult();
try
{
UserDto d = new UserDto();
result = _IAccount.UserRegistration(d);
}
catch
{
}
return(Ok(result));
}
public IGernalResult ChangePassword(int id, string password)
{
IGernalResult result = new GernalResult();
try
{
TblUser User = _dbContext.TblUser.Where(w => w.Id == id).FirstOrDefault();
User.Password = password;
int update = _dbContext.SaveChanges();
result.Succsefully = true;
result.Message = "Password change succsefully.";
}
catch
{
result.Succsefully = false;
result.Message = "Server eroor";
}
return(result);
}
public IGernalResult CancelOrder(int orderId)
{
IGernalResult result = new GernalResult();
try
{
TblOrder order = _dbContext.TblOrder.Where(w => w.Id == orderId).FirstOrDefault();
order.IsCanceled = true;
int save = _dbContext.SaveChanges();
result.Message = save > 0 ? "Order cancel Succsefully" : "Order not cancel";
result.Succsefully = save > 0 ? true : false;
}
catch
{
result.Message = "server error";
result.Succsefully = false;
}
return(result);
}
public IActionResult ChangePassword(ChangePassword password)
{
IGernalResult result = new GernalResult();
if (ModelState.IsValid)
{
try
{
var userId = HttpContext.Request.Cookies["user_id"];
result = _iAccount.ChangePassword(Convert.ToInt32(userId), password.ConfirmPassword);
ViewBag.msg = result.Succsefully ? "Your password has been changed" : "your password did not change";
}
catch
{
ViewBag.msg = "Server error";
}
}
return(View());
}
public IGernalResult DelteItem(int id)
{
IGernalResult result = new GernalResult();
try
{
result = getItem(id);
TblItem item = _dbContext.TblItem.Where(w => w.Id == id).FirstOrDefault();
item.IsDelete = true;
int delete = _dbContext.SaveChanges();
result.Succsefully = delete > 0 ? true : false;
result.Message = delete > 0 ? "Item deleted Succsefully" : "Item not delet.";
}
catch
{
result.Succsefully = false;
result.Message = "Server error";
}
return(result);
}
public IGernalResult EditItem(ItemDto dto)
{
IGernalResult result = new GernalResult();
TblItem item = _dbContext.TblItem.Where(w => w.Id == dto.Id).FirstOrDefault();
item.Name = dto.Name;
item.CategoryId = dto.CatogeryId;
item.Discription = dto.Discription;
item.ImageUrl = dto.Image;
item.Price = dto.Price;
item.Quantity = dto.Quantity;
int save = _dbContext.SaveChanges();
result.Succsefully = save > 0 ? true : false;
result.Message = save > 0 ? "Selling Item edit Succsefully" : "Selling Item not edit";
return(result);
}
public IGernalResult userLogin(UserDto dto)
{
IGernalResult result = new GernalResult();
try
{
TblUser user = _dbContext.TblUser.Where(w => w.Email == dto.Email).FirstOrDefault();
if (user != null)
{
if (user.Password == dto.Password)
{
var roles = _dbContext.MstRole.Where(w => w.Id == user.RoleId).FirstOrDefault();
result.Succsefully = true;
result.value = new UserDto
{
Id = user.Id,
RoleId = user.RoleId ?? 0,
Email = user.Email,
Role = roles.Role
};
}
else
{
result.Succsefully = false;
result.Message = "Password is wrong";
}
}
else
{
result.Succsefully = false;
result.Message = "Please enter a valid email.";
}
}
catch
{
result.Succsefully = false;
result.Message = "server error.";
}
return(result);
}
public IGernalResult AddUserRole(UserRoleDto dto)
{
IGernalResult result = new GernalResult();
try
{
//MstUserRole userRole = new MstUserRole
//{
// RoleId = dto.Id,
// RoleName = dto.RoleName,
//};
// _dbContext.Add(userRole);
int save = _dbContext.SaveChanges();
result.Succsefully = save > 0 ? true : false;
result.Message = save > 0 ? "UserRole added Succsefully." : "UserRole not add.";
}
catch
{
result.Succsefully = false;
result.Message = "Server error.";
}
return(result);
}
public IActionResult Index(SortModel model)
{
ViewBag.categories = _MasterService.GetCategories().Select(s => new CategoryDto
{
Id = s.Id,
CatogeryName = s.CatogeryName
});
IGernalResult result = new GernalResult();
//result = _IItem.getAllItem();
List <ItemDto> items = _IItem.getAllItem();
List <ItemModel> modelListFilter = new List <ItemModel>();
List <ItemModel> modelList = new List <ItemModel>();
foreach (var item in items)
{
ItemModel viewmodel = new ItemModel
{
Discription = item.Discription,
Id = item.Id,
Price = item.Price,
Quantity = item.Quantity,
Image = item.Image,
Name = item.Name,
SellerId = item.SellerId,
CategoryId = item.CatogeryId,
};
modelList.Add(viewmodel);
}
if (model.CategoryId > 0)
{
modelListFilter = modelList.Where(x => x.CategoryId == model.CategoryId).ToList();
}
if (model.PriceFilter == "desc")
{
if (model.CategoryId > 0)
{
modelListFilter = modelListFilter.OrderByDescending(x => Convert.ToInt32(x.Price)).ToList();
}
else
{
modelListFilter = modelList.OrderByDescending(x => Convert.ToInt32(x.Price)).ToList();
}
}
if (model.PriceFilter == "asec")
{
if (model.CategoryId > 0)
{
modelListFilter = modelListFilter.OrderBy(x => Convert.ToInt32(x.Price)).ToList();
}
else
{
modelListFilter = modelList.OrderBy(x => Convert.ToInt32(x.Price)).ToList();
}
}
if (model.PriceFilter != null || model.CategoryId > 0)
{
return(PartialView("_ProductItem", modelListFilter));
}
return(View(modelList));
}
