public ActionResult PropertyDeletedFailed() { OREDatabaseEntities1 db = new OREDatabaseEntities1(); var house = from e in db.PropertyTables orderby e.PId select e; return(View(house)); }
public ActionResult search(string Suburb, string PropertyType) { OREDatabaseEntities1 db = new OREDatabaseEntities1(); List <PropertyTable> SearchHouse = db.PropertyTables.Where(x => x.Suburb == Suburb && x.PropertyType == PropertyType).ToList(); return(View(SearchHouse)); }
public ActionResult addNewHouse([Bind(Include = "Suburb,Location,NumberofRooms,PropertyType,FloorArea,LandArea,RV,Email")] PropertyTable AddHouse) { using (OREDatabaseEntities1 houseEntites = new OREDatabaseEntities1()) { houseEntites.PropertyTables.Add(AddHouse); houseEntites.SaveChanges(); } return(View(AddHouse)); }
public ActionResult addNewSeller([Bind(Include = "FirstName,LastName,Address,PhoneNumber,EmailAddress")] SellerTable SellerRegistration) { using (OREDatabaseEntities1 db = new OREDatabaseEntities1()) { db.SellerTables.Add(SellerRegistration); db.SaveChanges(); } return(View(SellerRegistration)); }
public string regHouse(PropertyTable model) { try { OREDatabaseEntities1 db1 = new OREDatabaseEntities1(); db1.PropertyTables.Add(model); db1.SaveChanges(); return("Done"); } catch { return("Invalid"); } }
public string regSeller(SellerTable model) { try { OREDatabaseEntities1 db1 = new OREDatabaseEntities1(); db1.SellerTables.Add(model); db1.SaveChanges(); return("Done"); } catch { return("Invalid"); } }
public ActionResult del(int ID) { OREDatabaseEntities1 db = new OREDatabaseEntities1(); try { PropertyTable property = db.PropertyTables.Find(ID); db.PropertyTables.Remove(property); db.SaveChanges(); return(RedirectToAction("PropertyDeleted")); } catch (Exception) { return(RedirectToAction("PropertyDeletedFailed")); } }
public List <EmailAddressDropDown> GetDetailFroDropDown() { OREDatabaseEntities1 db2 = new OREDatabaseEntities1(); List <EmailAddressDropDown> result = new List <EmailAddressDropDown>(); var obj = db2.SellerTables.Select(s => s).ToList(); if (obj != null && obj.Count() > 0) { foreach (var data in obj) { EmailAddressDropDown model = new EmailAddressDropDown(); model.EmailAddress = data.EmailAddress; result.Add(model); } } return(result); }
public ActionResult del1(string email) { OREDatabaseEntities1 db1 = new OREDatabaseEntities1(); List <PropertyTable> pro = db1.PropertyTables.Where(x => x.Email == email).ToList(); foreach (var i in pro) { db1.PropertyTables.Remove(i); } bool listIsEmpty = !pro.Any(); if (listIsEmpty) { return(RedirectToAction("PropertyDeletedFailed")); } else { db1.SaveChanges(); return(RedirectToAction("PropertyDeleted")); } }