public string GetDistrict(int id)
{
RentAd rent = context.RentAds.SingleOrDefault(r => r.RentId == id);
District di = context.Districts.SingleOrDefault(d => d.DistrictId == rent.DistrictId);
return(di.DistrictName);
}
public string GetThana(int id)
{
RentAd rent = context.RentAds.SingleOrDefault(r => r.RentId == id);
Thana th = context.Thanas.SingleOrDefault(t => t.ThanaId == rent.ThanaId);
return(th.ThanaName);
}
public int Delete(int id)
{
RentAd RentToDelete = context.RentAds.SingleOrDefault(e => e.RentId == id);
context.RentAds.Remove(RentToDelete);
return(context.SaveChanges());
}
public int Edit(RentAd rent)
{
RentAd re = context.RentAds.SingleOrDefault(r => r.RentId == rent.RentId);
re.FlatNo = rent.FlatNo;
re.HouseNo = rent.HouseNo;
re.RoadNo = rent.RoadNo;
re.Area = rent.Area;
re.Description = rent.Description;
re.RentAmount = rent.RentAmount;
return(context.SaveChanges());
}
public int Insert(RentAd rent)
{
context.RentAds.Add(rent);
return(context.SaveChanges());
}
