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 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"));
}
}
