public List <dynamic> GetProperty()
{
try
{
List <PROPERTY> properties = db.PROPERTies.Where(zz => zz.AGENT_ID == null).ToList();
List <dynamic> PropertyList = new List <dynamic>();
AREA area = new AREA();
PROPERTYTYPE proptype = new PROPERTYTYPE();
if (properties != null)
{
foreach (var property in properties)
{
dynamic objprop = new ExpandoObject();
objprop.PROPERTYID = property.PROPERTYID;
proptype = db.PROPERTYTYPEs.Where(zz => zz.PROPERTYTYPEID == property.PROPERTYTYPEID).FirstOrDefault();
objprop.PROPERTYTYPE = proptype.PROPERTTYPEDESCRIPTION;
area = db.AREAs.Where(zz => zz.AREAID == property.AREAID).FirstOrDefault();
objprop.AREA = area.AREANAME;
objprop.ADDRESS = property.ADDRESS;
PropertyList.Add(objprop);
}
}
return(PropertyList);
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult DeleteOwner(int id)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
try
{
PROPERTYTYPE propertyTypeDetails = db.PROPERTYTYPEs.Find(id);
if (propertyTypeDetails == null)
{
return(NotFound());
}
db.PROPERTYTYPEs.Remove(propertyTypeDetails);
db.SaveChanges();
return(Ok(propertyTypeDetails));
}
catch (Exception)
{
return(null);
}
}
public IHttpActionResult PutOwnerMaster(PROPERTYTYPE PropertyType)
{
db.Configuration.ProxyCreationEnabled = false;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
PROPERTYTYPE objEmp = new PROPERTYTYPE();
objEmp = db.PROPERTYTYPEs.Find(PropertyType.PROPERTYTYPEID);
if (objEmp != null)
{
objEmp.PROPERTTYPEDESCRIPTION = PropertyType.PROPERTTYPEDESCRIPTION;
//objEmp.TIMESVISITED = PropertyType.TIMESVISITED;
}
int i = this.db.SaveChanges();
}
catch (Exception)
{
return(null);
}
return(Ok(PropertyType));
}
public dynamic PutPropertyMaster(dynamic property)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{ int ID = property.PROPERTYID;
PROPERTY objEmp = new PROPERTY();
objEmp = db.PROPERTies.Where(ww => ww.PROPERTYID == ID).FirstOrDefault();
if (objEmp != null)
{
string areaname = property.AREA;
string propertype = property.PROPERTYTYPE;
AREA area = db.AREAs.Where(zz => zz.AREANAME == areaname).FirstOrDefault();
PROPERTYTYPE type = db.PROPERTYTYPEs.Where(zz => zz.PROPERTTYPEDESCRIPTION == propertype).FirstOrDefault();
objEmp.AREAID = property.AREA;
objEmp.PROPERTYTYPEID = property.PROPERTYTYPE;
// objEmp.PROPERTYSTATUSID = property.PROPERTYSTATUSID;
///objEmp.AGENT_ID = property.AGENT_ID;
objEmp.PROPERTYDESCRIPTION = property.PROPERTYDESCRIPTION;
objEmp.ADDRESS = property.ADDRESS;
objEmp.SIZE = property.SIZE;
objEmp.NUMBBATH = property.NUMBBATH;
objEmp.NUMBED = property.NUMBED;
objEmp.GARDEN = property.GARDEN;
objEmp.ADDITIONALINFO = property.ADDITIONALINFO;
objEmp.AVAILABLEDATE = property.AVAILABLEDATE;
db.SaveChanges();
RENTALAMOUNT amnt = new RENTALAMOUNT();
amnt = db.RENTALAMOUNTs.Where(qq => qq.PROPERTYID == objEmp.PROPERTYID).FirstOrDefault();
amnt.AMOUNT = property.RENTALAMOUNT;
amnt.DATE = DateTime.Today;
db.SaveChanges();
}
}
catch (Exception)
{
return(null);
}
return(Ok(property));
}
public dynamic AddCount(int ID)
{
try
{
int?propertyID = db.PROPERTies.Where(kk => kk.PROPERTYID == ID).Select(hh => hh.PROPERTYTYPEID).FirstOrDefault();
PROPERTYTYPE addcount = db.PROPERTYTYPEs.Where(ll => ll.PROPERTYTYPEID == propertyID).FirstOrDefault();
var counter = addcount.TIMESVISITED;
addcount.TIMESVISITED = counter + 1;
db.SaveChanges();
}
catch (Exception)
{
return(null);
}
return(Ok());
}
public IHttpActionResult PostOwner(PROPERTYTYPE data)
{
INF370Entities db = new INF370Entities();
db.Configuration.ProxyCreationEnabled = false;
try
{
db.PROPERTYTYPEs.Add(data);
db.SaveChanges();
}
catch (Exception)
{
return(null);
}
return(Ok(data));
}
public IHttpActionResult GetPropertyTypeById(string PropertyTypeID)
{
db.Configuration.ProxyCreationEnabled = false;
PROPERTYTYPE objEmp = new PROPERTYTYPE();
try
{
int ID = Convert.ToInt32(PropertyTypeID);
objEmp = db.PROPERTYTYPEs.Find(ID);
if (objEmp == null)
{
return(NotFound());
}
}
catch (Exception)
{
return(null);
}
return(Ok(objEmp));
}
public PropertiesBonus(PROPERTYTYPE _type, float _valuePro)
{
_typeProperty = _type;
_valueProperty = _valuePro;
}
