public IQueryable <Relative> GetRelatives()
{
var dataContext = new RelativeModelDataContext();
var relatives = (from m in dataContext.Relatives
select m);
return(relatives);
}
public void addRelative(Relative relative)
{
var dataContext = new RelativeModelDataContext();
dataContext.Relatives.InsertOnSubmit(relative);
dataContext.SubmitChanges();
using (System.IO.StreamWriter file =
new System.IO.StreamWriter(@"C:\Users\Public\homecarelog.txt", true))
{
file.WriteLine(DateTime.Now + " new relative with id " + relative.Id + " created");
}
}
public void deleteRelativeById(int?id)
{
var dataContext = new RelativeModelDataContext();
var query = (from m in dataContext.Relatives
where m.Id == id
select m);
dataContext.Relatives.DeleteOnSubmit(query.First());
dataContext.SubmitChanges();
using (System.IO.StreamWriter file =
new System.IO.StreamWriter(@"C:\Users\Public\homecarelog.txt", true))
{
file.WriteLine(DateTime.Now + " relative with id " + id + " deleted");
}
}
public Relative getRelativeById(int?id)
{
var dataContext = new RelativeModelDataContext();
var query = (from m in dataContext.Relatives
where m.Id == id
select m);
var relative = query.First();
if (relative != null)
{
return(relative);
}
else
{
return(null);
}
}
public void updateRelative(Relative relative)
{
var dataContext = new RelativeModelDataContext();
var query = (from m in dataContext.Relatives
where m.Id == relative.Id
select m);
query.First().name = relative.name;
query.First().relation = relative.relation;
query.First().email = relative.email;
query.First().phone_number = relative.phone_number;
query.First().customer_Id = relative.customer_Id;
dataContext.SubmitChanges();
using (System.IO.StreamWriter file =
new System.IO.StreamWriter(@"C:\Users\Public\homecarelog.txt", true))
{
file.WriteLine(DateTime.Now + " relative with id " + relative.Id + " updated");
}
}
