public static void AddTransaction(Transaction transaction)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
conn.Transactions.InsertOnSubmit(transaction);
conn.SubmitChanges();
}
}
public static void AddEstate(Estate estate)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
conn.Estates.InsertOnSubmit(estate);
conn.SubmitChanges();
}
}
public static void AddClient(Client client)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
conn.Clients.InsertOnSubmit(client);
conn.SubmitChanges();
}
}
public static void AddAd(Ad ad)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
conn.Ads.InsertOnSubmit(ad);
conn.SubmitChanges();
}
}
public static void DeleteClient(Client client)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
Client cli = (from c in conn.Clients
where c.Id == client.Id
select c).FirstOrDefault();
conn.Clients.DeleteOnSubmit(cli);
conn.SubmitChanges();
}
}
public static void DeleteEstate(Estate estate)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
Estate est = (from e1 in conn.Estates
where e1.Id == estate.Id
select e1).FirstOrDefault();
conn.Estates.DeleteOnSubmit(est);
conn.SubmitChanges();
}
}
public static void UpdateClient(Client client)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
Client cli = (from c in conn.Clients
where c.Id == client.Id
select c).FirstOrDefault();
cli.FirstName = client.FirstName;
cli.LastName = client.LastName;
conn.SubmitChanges();
}
}
public static void UpdateEstate(Estate estate)
{
using (RealEstateDataDataContext conn = new RealEstateDataDataContext())
{
Estate est = (from e1 in conn.Estates
where e1.Id == estate.Id
select e1).FirstOrDefault();
est.Name = estate.Name;
est.Description = estate.Description;
est.Fee = estate.Fee;
est.Owner = estate.Owner;
conn.SubmitChanges();
}
}
