public ActionResult imageupload(HttpPostedFileBase file, MarketShare.Models.admin md) { if (file != null && file.ContentLength > 0) { try { string filename = "pimg" + md.productid + ".jpg"; string path = Path.Combine(Server.MapPath("~/productimage"), Path.GetFileName(filename)); file.SaveAs(path); var cm = (from data in db.product_master where data.productid == md.productid select data).FirstOrDefault(); cm.productimage = filename; db.SaveChanges(); //con.Open(); //SqlCommand cmd = new SqlCommand("update product_master set productimage='" + filename + "' where productid='" + md.productid + "'", con); //cmd.ExecuteNonQuery(); //con.Close(); ViewBag.Message = "File uploaded successfully"; } catch (Exception ex) { ViewBag.Message = "ERROR:" + ex.Message.ToString(); } } else { ViewBag.Message = "You have not specified a file."; } return(RedirectToAction("manageproduct", "Admin")); }
public ActionResult addproduct(MarketShare.Models.admin md) { int categoryid = 1; var a = (from clist in db.product_category where clist.category == md.category && clist.subcategory == md.subcategory select new { clist.categoryid }).ToList(); if (a.FirstOrDefault() != null) { categoryid = a.FirstOrDefault().categoryid; } try { DB.product_master obj = new DB.product_master(); obj.productid = md.productid; obj.categoryid = categoryid; obj.productname = md.productname; obj.mrp = md.mrp; obj.sellingprice = md.sellingprice; obj.brand = md.brand; obj.quantity = md.quantity; obj.size = md.size; obj.color = md.color; obj.shortdescp = md.shortdescp; obj.longdescp = md.longdescp; obj.productimage = "noimg.jpg"; obj.sellerid = Session["adminid"].ToString(); obj.updatedate = DateTime.Now; obj.addeddate = DateTime.Now; obj.status = md.status; db.product_master.Add(obj); db.SaveChanges(); return(View()); } catch (Exception ex) { throw ex; } finally { ViewBag.msg = "Successfully Submitted"; ModelState.Clear(); } }
public ActionResult adminforgotpassword(MarketShare.Models.admin md) { var u = (from userlist in db.admin_master where userlist.adminid == md.adminid && userlist.emailid == md.emailid select new { userlist.password }).ToList(); if (u.FirstOrDefault() != null) { ViewBag.msg = "Your Password is:" + u.FirstOrDefault().password; } else { ViewBag.msg = "Invalid input Credentials."; } return(View()); }
public ActionResult adminlogin(MarketShare.Models.admin md) { var a = (from userlist in db.admin_master where userlist.adminid == md.adminid && userlist.password == md.password select new { userlist.adminid, userlist.password }).ToList(); if (a.FirstOrDefault() != null) { Session["adminid"] = a.FirstOrDefault().adminid; return(RedirectToAction("adminhome", "Admin")); } else { ViewBag.msg = "Invalid login Credentials."; } return(View()); }
public ActionResult addcategory(MarketShare.Models.admin md) { try { DB.product_category obj = new DB.product_category(); obj.categoryid = md.categoryid; obj.category = md.category; obj.subcategory = md.subcategory; obj.type = md.type; db.product_category.Add(obj); db.SaveChanges(); return(View()); } catch (Exception ex) { throw ex; } finally { ViewBag.msg = "Successfully Submitted"; ModelState.Clear(); } }