// GET: Account
public ActionResult Index()
{
using (Mydbcontext db = new Mydbcontext())
{
return(View(db.UserDetails.ToList()));
}
}
public ActionResult SetRatings(int id, double rate)
{
Mydbcontext db = new Mydbcontext();
Ratings r = new Ratings();
r.Rate = rate;
r.Businessid = id;
r.Username = Session["Username"].ToString();
db.Ratings.Add(r);
db.SaveChanges();
int i = 0;
double ratings = 0;
var bd = from t in db.Ratings where t.Businessid == id select t;
foreach (var t in bd)
{
ratings += t.Rate;
i++;
}
ratings /= i;
ratings = Math.Truncate(ratings * 100) / 100;
var details = new BusinessDetails()
{
Id = id,
Overall = ratings
};
db.BusinessDetails.Attach(details);
db.Entry(details).Property(x => x.Overall).IsModified = true;
db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();
return(RedirectToAction("Details", "Advertise", new { id = id }));
}
public ActionResult Login(UserDetails user)
{
if (user.Username == "dishank" && user.Password == "hello@123")
{
Session["Username"] = user.Username.ToString();
return(RedirectToAction("Users", "Admin"));
}
else
{
using (Mydbcontext db = new Mydbcontext())
{
var usr = db.UserDetails.Where(u => u.Username == user.Username && u.Password == user.Password).FirstOrDefault();
if (usr != null)
{
Session["Username"] = usr.Username.ToString();
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.error = "Username or Password is Invalid!";
}
}
return(View());
}
}
public ActionResult AddBusiness(BusinessDetails details, FormCollection mydetails, string Cat)
{
if (Session["Username"] != null)
{
string fileName = Path.GetFileNameWithoutExtension(details.Imagefile.FileName);
string extension = Path.GetExtension(details.Imagefile.FileName);
fileName += DateTime.Now.ToString("yymmssfff") + extension;
details.Imagepath = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
details.Imagefile.SaveAs(fileName);
Mydbcontext db = new Mydbcontext();
BusinessDetails cat = new BusinessDetails()
{
Businessname = Convert.ToString(mydetails["Businessname"]),
Ownername = Convert.ToString(mydetails["Ownername"]),
//Category = Convert.ToString(mydetails["Category"]),
Category = Cat,
Description = Convert.ToString(mydetails["Description"]),
Address = Convert.ToString(mydetails["Address"]),
Mobile = Convert.ToString(mydetails["Mobile"]),
Imagepath = details.Imagepath,
};
db.BusinessDetails.Add(cat);
db.SaveChanges();
ViewBag.MyCategory = from t in db.Categories select t.Categoryname;
ModelState.Clear();
ViewBag.Msg = "Your Business is Successfully added :)";
return(View());
}
else
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Index()
{
Mydbcontext db = new Mydbcontext();
ViewBag.Popular = from t in db.BusinessDetails.OrderByDescending(a => a.Overall) select t;
return(View());
}
public ActionResult Edit()
{
string name = Session["Username"].ToString();
Mydbcontext db = new Mydbcontext();
UserDetails user = db.UserDetails.FirstOrDefault(u => u.Username.Equals(name));
return(View(user));
}
public ActionResult Business(string name)
{
Mydbcontext db = new Mydbcontext();
var bd = from t in db.BusinessDetails where t.Category == name select t;
if (bd != null)
{
return(View(bd));
}
return(HttpNotFound());
}
public ActionResult MyCategories()
{
if (Session["Username"].ToString() == "dishank")
{
Mydbcontext db = new Mydbcontext();
return(View(from t in db.Categories select t));
}
else
{
return(RedirectToAction("Error", "Home"));
}
}
// GET: Advertise
public ActionResult Details(int id)
{
Mydbcontext db = new Mydbcontext();
BusinessDetails bd = db.BusinessDetails.Find(id);
if (bd != null)
{
ViewBag.Rated = from t in db.Ratings where t.Businessid == id select t;
return(View(bd));
}
return(HttpNotFound());
}
public ActionResult DeleteCategory(string Cat)
{
if (Session["Username"].ToString() == "dishank")
{
Mydbcontext db = new Mydbcontext();
Categories cat = db.Categories.FirstOrDefault(u => u.Categoryname.Equals(Cat));
db.Categories.Remove(cat);
db.SaveChanges();
return(RedirectToAction("MyCategories", "Admin"));
}
else
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Delete(string Username)
{
if (Session["Username"].ToString() == "dishank")
{
Mydbcontext db = new Mydbcontext();
UserDetails user = db.UserDetails.FirstOrDefault(u => u.Username.Equals(Username));
db.UserDetails.Remove(user);
db.SaveChanges();
return(RedirectToAction("Users", "Admin"));
}
else
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult AddBusiness()
{
Mydbcontext db = new Mydbcontext();
//List<SelectListItem> Cat= null;
//var Item = (from s in db.Categories
// select new SelectListItem
// {
// Text = s.Categoryname,
// Value = s.Categoryname
// }).Distinct();
//Cat = Item.ToList();
//ViewBag.MyCategory= Cat;
ViewBag.MyCategory = from t in db.Categories select t.Categoryname;
return(View());
}
public ActionResult Edit(UserDetails details)
{
if (Session["Username"] != null)
{
string name = Session["Username"].ToString();
Mydbcontext db = new Mydbcontext();
UserDetails user = db.UserDetails.FirstOrDefault(u => u.Username.Equals(name));
user.Firstname = details.Firstname;
user.Lastname = details.Lastname;
user.Email = details.Email;
user.Password = details.Password;
user.ConfirmPassword = details.ConfirmPassword;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
// GET: Category
public ActionResult Index()
{
if (Session["Username"] == null)
{
Mydbcontext db = new Mydbcontext();
return(View(from t in db.Categories select t));
}
if (Session["Username"].ToString() == "dishank")
{
return(Redirect("~/Admin/MyCategories"));
}
else
{
Mydbcontext db = new Mydbcontext();
return(View(from t in db.Categories select t));
}
}
public ActionResult CreateCategory(Categories cat)
{
string fileName = Path.GetFileNameWithoutExtension(cat.Imagefile.FileName);
string extension = Path.GetExtension(cat.Imagefile.FileName);
fileName += DateTime.Now.ToString("yymmssfff") + extension;
cat.CategoryPath = "~/Categories/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Categories/"), fileName);
cat.Imagefile.SaveAs(fileName);
Mydbcontext db = new Mydbcontext();
db.Categories.Add(cat);
db.SaveChanges();
ModelState.Clear();
ViewBag.Msg = "Category is Successfully added :)";
return(View());
}
public ActionResult Register(UserDetails account)
{
if (ModelState.IsValid)
{
using (Mydbcontext db = new Mydbcontext())
{
if (db.UserDetails.Where(u => u.Username == account.Username).FirstOrDefault() != null)
{
ViewBag.error = "Username already exist";
return(View());
}
db.UserDetails.Add(account);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = account.Firstname + " " + account.Lastname + " successfully registered.";
}
return(View());
}
public Service()
{
this._mydbcontext = new Mydbcontext();
}
// GET: Admin
public ActionResult Users()
{
Mydbcontext db = new Mydbcontext();
return(View(from t in db.UserDetails select t));
}
