public ActionResult Add()
{
using (ucmmarketplaceEntities itemimage = new ucmmarketplaceEntities())
{
var categorydatalist = itemimage.categories.ToList();
SelectList catlist = new SelectList(categorydatalist, "CategoryID", "CategoryName");
ViewBag.categoryname = catlist;
List <SelectListItem> Condition = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "New", Text = "New", /*Selected = true, Disabled = true*/
},
new SelectListItem()
{
Value = "BarelyUsed", Text = "BarelyUsed"
},
new SelectListItem()
{
Value = "Used", Text = "Used"
},
};
ViewBag.ItemCondition = Condition;
return(View());
}
}
public ActionResult ShowActivity()
{
ucmmarketplaceEntities en = new ucmmarketplaceEntities();
List <item> itemlists = en.items.ToList();
if (Session["UserName"] != null)
{
var username = Session["UserName"];
var UserID = en.users.Where(x => x.UserName == username.ToString()).Select(x => x.UserId).FirstOrDefault();
ViewBag.UserId = UserID;
List <Itemviewmodel> itemlist = itemlists.Select(x => new Itemviewmodel
{
ItemID = x.ItemID,
Title = x.Title,
Price = x.Price,
Description = x.Description,
Condition = x.Condition,
ImagePath = x.ImagePath,
CategoryName = x.category.CategoryName,
Status = x.Status,
UploadUserID = x.UploadUserID
}).Where(x => x.UploadUserID == UserID).ToList();
return(View(itemlist));
}
else
{
return(View());
}
}
public ActionResult View(int id)
{
item itemimage = new item();
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
List <item> itemlists = en.items.ToList();
if (Session["UserName"] != null)
{
var username = Session["UserName"];
var UserID = en.users.Where(x => x.UserName == username.ToString()).Select(x => x.UserId).FirstOrDefault();
ViewBag.UserId = UserID;
}
List <Itemviewmodel> itemlist = itemlists.Select(x => new Itemviewmodel
{
ItemID = x.ItemID,
Title = x.Title,
Price = x.Price,
Description = x.Description,
Condition = x.Condition,
ImagePath = x.ImagePath,
CategoryName = x.category.CategoryName,
Status = x.Status,
UploadUserID = x.UploadUserID
}).Where(x => x.ItemID == id).ToList();
//To get Upload User data
GetUserData1(id);
return(View(itemlist));
}
}
public PartialViewResult FilterbyCategory(int CategoryID)
{
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
List <item> itemlists = en.items.ToList();
List <Itemviewmodel> itemlist = itemlists.Select(x => new Itemviewmodel
{
ItemID = x.ItemID,
Title = x.Title,
Description = x.Description,
Condition = x.Condition,
ImagePath = x.ImagePath,
CategoryID = x.CategoryID,
CategoryName = x.category.CategoryName,
Status = x.Status
}).Where(x => x.CategoryID == CategoryID)
.OrderByDescending(x => x.ItemID)
.ToList();
if (itemlist != null || itemlist.Count == 0)
{
return(PartialView(itemlist));
}
else
{
return(PartialView(itemlists));
}
}
}
public bool IsEmailExist(string UserName, string EmailID)
{
using (ucmmarketplaceEntities entity = new ucmmarketplaceEntities())
{
var record = entity.users.Where(x => x.UserName == UserName || x.EmailId == EmailID).Select(x => x).FirstOrDefault();
//var v = entity.users.Where(a => a.EmailId == email.EmailId).FirstOrDefault();
return(record != null);
}
}
public bool IsValidLogin(string UserName, string Password)
{
using (ucmmarketplaceEntities entity = new ucmmarketplaceEntities())
{
string UserPassowrd = Crypto.Hash(Password);
var v = entity.users.Where(a => a.UserName == UserName && a.Password == UserPassowrd).Select(a => new { a.UserName, a.Password, a.EmailId }).FirstOrDefault();
if (v == null)
{
ViewBag.message = "Invalid Login Details. If not already registered, please Register.";
}
return(v != null);
}
}
public ActionResult Index(string search)
{
if (search == "")
{
ucmmarketplaceEntities en = new ucmmarketplaceEntities();
return(View(en.items.ToList()));
}
else
{
ucmmarketplaceEntities en = new ucmmarketplaceEntities();
return(View(en.items.Where(x => x.Title.Contains(search) || search == null).ToList()));
}
}
public ActionResult Add(item item)
{
int UserID;
var username = Session["UserName"].ToString();
string imagefilename = "";
ucmmarketplaceEntities en = new ucmmarketplaceEntities();
UserID = en.users.Where(x => x.UserName == username).Select(x => x.UserId).FirstOrDefault();
foreach (var file in item.Imagefile)
{
string filename = Path.GetFileNameWithoutExtension(file.FileName);
string extension = Path.GetExtension(file.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
if (Directory.Exists("~/ItemImages") == false)
{
Directory.CreateDirectory(Server.MapPath("~/ItemImages"));
}
if (imagefilename == "")
{
imagefilename = "~/ItemImages/" + filename;
}
else
{
imagefilename = imagefilename + "|" + "~/ItemImages/" + filename;
}
filename = Path.Combine(Server.MapPath("~/ItemImages/"), filename);
file.SaveAs(filename);
}
using (ucmmarketplaceEntities itemimage = new ucmmarketplaceEntities())
{
if (imagefilename != "")
{
item.ImagePath = imagefilename;
}
item.Status = "Available";
item.Description = item.Description;
item.Condition = item.ItemCond;
item.Price = Convert.ToDouble(item.Price);
item.CategoryList = item.CategoryList;
item.CategoryID = Convert.ToInt32(item.CategoryList);
item.UploadUserID = Convert.ToInt32(UserID);
itemimage.items.Add(item);
itemimage.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("Index", "Home"));
}
public ActionResult Edit(int id)
{
item itemimage = new item();
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
itemimage = en.items.Where(x => x.ItemID == id).FirstOrDefault();
var categorydatalist = en.categories.ToList();
SelectList catlist = new SelectList(categorydatalist, "CategoryID", "CategoryName");
ViewBag.categoryname = catlist;
}
List <SelectListItem> Condition = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "New", Text = "New", /*Selected = true, Disabled = true*/
},
new SelectListItem()
{
Value = "BarelyUsed", Text = "BarelyUsed"
},
new SelectListItem()
{
Value = "Used", Text = "Used"
},
};
ViewBag.ItemCondition = Condition;
List <SelectListItem> ItemStatus = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "Available", Text = "Available", /*Selected = true, Disabled = true*/
},
new SelectListItem()
{
Value = "Sold", Text = "Sold"
},
new SelectListItem()
{
Value = "PendingForPickup", Text = "PendingForPickup"
},
};
ViewBag.ItemStatus = ItemStatus;
return(View(itemimage));
}
//TODO Shweta
// GET: Show Message
public PartialViewResult ShowMessage(int itemId)
{
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
List <item> itemlists = en.items.ToList();
List <GetUserData> itemlist = itemlists.Select(x => new GetUserData
{
ItemID = x.ItemID,
UploadUserID = x.UploadUserID,
EmailId = x.user.EmailId,
UserId = x.user.UserId,
UserName = x.user.UserName,
ItemTitle = x.Title,
}).Where(x => x.ItemID == itemId && x.UploadUserID == x.UserId).ToList();
return(PartialView(itemlist));
}
}
public ActionResult SaveItemtoWishlist(int itemid)
{
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
wishlist objwishlist = new wishlist();
if (Session["UserName"] != null || Session["UserName"].ToString() != "")
{
int UserID;
var username = Session["UserName"].ToString();
UserID = en.users.Where(x => x.UserName == username).Select(x => x.UserId).FirstOrDefault();
objwishlist.UserID = UserID;
objwishlist.ItemID = itemid;
en.wishlists.Add(objwishlist);
en.SaveChanges();
}
}
return(View());
}
public ActionResult Login(user user)
{
if (ModelState.IsValid)
{
var validLogin = IsValidLogin(user.UserName, user.Password);
if (validLogin == true)
{
ViewBag.Status = true;
Session["UserName"] = user.UserName;
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
user email = new user();
string password = Crypto.Hash(user.Password);
email = en.users.Where(x => x.UserName == user.UserName && x.Password == password).Select(x => x).FirstOrDefault();
Session["EmailId"] = email.EmailId;
}
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Status = false;
return(View());
}
//Email is already Exists
//var isExist = IsEmailExist(user.UserName);
//if (isExist)
//{
// ModelState.AddModelError("AccountExist", "Account already exists");
// return View(user);
//}
////password hashing
//user.Password = Crypto.Hash(user.Password);
////save to databse
//user.IsActive = false;
//using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
//{
// en.userprofiles.Add(user);
// en.SaveChanges();
//}
}
return(View());
}
public void GetUserData1(int itemid)
{
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
string EmailAdd;
List <item> itemlists = en.items.ToList();
List <GetUserData> itemlist = itemlists.Select(x => new GetUserData
{
ItemID = x.ItemID,
UploadUserID = x.UploadUserID,
EmailId = x.user.EmailId,
UserId = x.user.UserId,
UserName = x.user.UserName,
ItemTitle = x.Title,
}).Where(x => x.ItemID == itemid && x.UploadUserID == x.UserId).ToList();
EmailAdd = itemlist.First().EmailId.ToString();
ViewBag.EmailAdd = EmailAdd;
}
}
public ActionResult Registration([Bind(Exclude = "UserId")] user user)
{
bool Status = false;
string message = "";
//Model Validation
if (ModelState.IsValid)
{
//Email is already Exists
var isExist = IsEmailExist(user.UserName, user.EmailId);
if (isExist)
{
ModelState.AddModelError("AccountExist", "Account already exist.");
Status = false;
return(View(user));
}
//password hashing
user.Password = Crypto.Hash(user.Password);
//save to databse
// user.IsActive = false;
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
en.users.Add(user);
en.SaveChanges();
}
//send email to user
SendVerificationemail(user.EmailId);
message = user.UserName + " your registration is successful. Please login to your account.";
Status = true;
}
else
{
message = "Invalid Request";
Status = false;
}
ViewBag.Message = message;
ViewBag.Status = Status;
return(View(user));
}
public ActionResult Edit(item item)
{
item itemimage = new item();
//category cg = new category();
//cg.categoryList = new SelectList(cg.GetCategoryList(), "CategoryID", "CateoryName");
using (ucmmarketplaceEntities en = new ucmmarketplaceEntities())
{
int UserID;
var username = Session["UserName"];
UserID = en.users.Where(x => x.UserName == username.ToString()).Select(x => x.UserId).FirstOrDefault();
itemimage = en.items.Where(x => x.ItemID == item.ItemID && x.UploadUserID == UserID).FirstOrDefault();
string imagefilename = "";
string filename1 = "";
foreach (var file in item.Imagefile)
{
if (file != null)
{
string filename = Path.GetFileNameWithoutExtension(file.FileName);
string extension = Path.GetExtension(file.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
// item.ImagePath = "~/ItemImages/" + filename;
filename1 = Path.Combine(Server.MapPath("~/ItemImages/"), filename);
file.SaveAs(filename1);
if (imagefilename == "")
{
imagefilename = "~/ItemImages/" + filename;
}
else
{
imagefilename = imagefilename + "|" + "~/ItemImages/" + filename;
}
}
}
if (ModelState.IsValid)
{
itemimage.Title = item.Title;
if (imagefilename == null || imagefilename == "")
{
itemimage.ImagePath = itemimage.ImagePath;
}
else
{
itemimage.ImagePath = imagefilename;
}
itemimage.Description = item.Description;
if (item.Status != "" || item.Status != null)
{
itemimage.Status = item.Status;
}
else
{
itemimage.Status = itemimage.Status;
}
if (item.Condition != "" || item.Condition != null)
{
itemimage.Condition = item.Condition;
}
else
{
itemimage.Condition = itemimage.Condition;
}
itemimage.Price = item.Price;
itemimage.CategoryList = item.CategoryList;
itemimage.CategoryID = item.CategoryID;//Convert.ToInt32(cg.categoryList.SelectedValue);
itemimage.UploadUserID = UserID;
itemimage.Imagefile = item.Imagefile;
en.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("View", new { id = itemimage.ItemID }));
}
}
public ActionResult Index()
{
ucmmarketplaceEntities en = new ucmmarketplaceEntities();
return(View(en.categories.ToList()));
}
public PartialViewResult GetCategory()
{
ucmmarketplaceEntities en = new ucmmarketplaceEntities();
return(PartialView(en.categories.ToList()));
}
