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