public void UpdatePropertyDetails(Property property, Dictionary <int, int> propertyValues)
{
using (PropertyContext propertyContext = new PropertyContext())
{
propertyContext.Entry(property).State = EntityState.Modified;
PropertyValues values = new PropertyValues();
bool flag = true;
List <int> propertyId = (from valuesObject in propertyContext.PropertyValues where property.PropertyId == valuesObject.PropertyId select valuesObject.PropertyId).ToList();
int count = 0;
while (flag)
{
if (property.PropertyId == (propertyId[0]))
{
foreach (KeyValuePair <int, int> item in propertyValues)
{
values = (from valueObject in propertyContext.PropertyValues where valueObject.ValueId == item.Key select valueObject).Single();
values.Value = propertyValues[item.Key];
propertyContext.SaveChanges();
}
count++;
}
if (count == propertyValues.Count)
{
flag = false;
}
}
propertyContext.SaveChanges();
}
}
public int SignUp(User user)
{
PropertyContext propertyContext = new PropertyContext();
propertyContext.User.Add(user);
return(propertyContext.SaveChanges());
}
//buyer
public int Create(BuyerProperty buyerProperty)
{
using (PropertyContext propertyContext = new PropertyContext())
{
propertyContext.BuyerProperty.Add(buyerProperty);
return(propertyContext.SaveChanges());
}
}
public void Delete(int landId)
{
using (PropertyContext propertyContext = new PropertyContext())
{
Property propertyvalue = propertyContext.Property.Find(landId);
propertyContext.Property.Remove(propertyvalue);
List <PropertyValues> propertyValues = (from value in propertyContext.PropertyValues where value.PropertyId == landId select value).ToList();
for (int index = 0; index < propertyValues.Count; index++)
{
propertyContext.PropertyValues.Remove(propertyValues[index]);
}
propertyContext.SaveChanges();
}
}
public void AddPropertyValue(PropertyValues propertyValues, int [] Value, int[] PropertyFeature)
{
using (PropertyContext propertyContext = new PropertyContext())
{
int index = 0;
foreach (int value in Value)
{
propertyValues.Value = value;
propertyValues.PropertyFeatureId = PropertyFeature[index];
index++;
propertyContext.PropertyValues.Add(propertyValues);
propertyContext.SaveChanges();
}
}
}
public void AcceptRequest(BuyerProperty buyerProperty)
{
buyerProperty.Status = "Accept";
Property property = new Property();
property.PropertyId = buyerProperty.PropertyId;
property.PropertyTypeID = buyerProperty.PropertyTypeID;
property.UserId = buyerProperty.UserId;
property.Image = buyerProperty.Image;
property.Location = buyerProperty.Location;
property.Price = buyerProperty.Price;
property.Area = buyerProperty.Area;
using (PropertyContext propertyContext = new PropertyContext())
{
propertyContext.Property.Add(property);
propertyContext.SaveChanges();
}
}
