public ActionResult Edit(SchoolViewModel model, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
try
{
if (file != null)
{
SchoolBookDBEntities db = new SchoolBookDBEntities();
School obj = db.Schools.Find(model.id);
string previous_image_path = obj.ImageUrl;
if (System.IO.File.Exists(previous_image_path))
{
System.IO.File.Delete(previous_image_path);
}
string fileName = Path.GetFileName(file.FileName);
string path = "~/Content/Images/" + fileName;
file.SaveAs(Server.MapPath(path));
model.file = path;
School school = db.Schools.Single(s => s.SchoolD == model.id);
school.Name = model.SchoolName;
school.Address = model.Address;
school.City = model.City;
school.Adm_Fee = model.AdmissionFee;
school.Fee_PG_Middle = model.FeePG_Middle;
school.Fee_Matric_OLevel = model.FeeMatric_Olevels;
school.ImageUrl = model.file;
school.PhoneNo = model.PhoneNo;
db.SaveChanges();
ViewBag.FileStatus = "Succesfully Edited";
}
else
{
SchoolBookDBEntities db = new SchoolBookDBEntities();
School obj = db.Schools.Find(model.id);
School school = db.Schools.Single(s => s.SchoolD == model.id);
school.Name = model.SchoolName;
school.Address = model.Address;
school.City = model.City;
school.Adm_Fee = model.AdmissionFee;
school.Fee_PG_Middle = model.FeePG_Middle;
school.Fee_Matric_OLevel = model.FeeMatric_Olevels;
school.PhoneNo = model.PhoneNo;
db.SaveChanges();
ViewBag.FileStatus = "Succesfully Edited";
}
}
catch
{
ViewBag.FileStatus = "Some error in Updating";
}
}
return(View("Edit"));
}
public ActionResult Rate(int id, Rating_Review model, string url)
{
SchoolBookDBEntities db = new SchoolBookDBEntities();
Rating_Reviews r = new Rating_Reviews();
var user = db.AspNetUsers.Single(u => u.UserName == User.Identity.Name);
string name = user.FullName;
r.AddedBy = name;
r.SchoolID = id;
r.Rating = model.Rating;
if (model.Review != null)
{
r.Review = model.Review;
}
db.Rating_Reviews.Add(r);
db.SaveChanges();
return(Redirect(url));
}
public ActionResult Add(SchoolViewModel obj, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
try
{
if (file != null)
{
//var allowedExtensions = new[] {".Jpg", ".png", ".jpg", "jpeg" };
SchoolBookDBEntities db = new SchoolBookDBEntities();
School school = new School();
school.Name = obj.SchoolName;
school.City = obj.City;
school.Address = obj.Address;
school.PhoneNo = obj.PhoneNo;
school.Adm_Fee = obj.AdmissionFee;
school.Fee_PG_Middle = obj.FeePG_Middle;
school.Fee_Matric_OLevel = obj.FeeMatric_Olevels;
school.AddedBy = User.Identity.GetUserId();
//var ext = Path.GetExtension(file.FileName);
string fileName = Path.GetFileName(file.FileName);
string path = "~/Content/Images/" + fileName;
file.SaveAs(Server.MapPath(path));
school.ImageUrl = path;
db.Schools.Add(school);
db.SaveChanges();
SchoolViewModel vm = new SchoolViewModel();
return(RedirectToAction("Add"));
}
ViewBag.FileStatus = "School Successfully Added";
}
catch
{
ViewBag.FileStatus = "Some Error Occurred";
}
}
return(View("Add"));
}
