private Entity.ExtendedSubject[] GetSubjects(int id)
{
var ids = (from i1 in dbContext.Invoice
where i1.Id == id
select new
{
i1.Subject_For_Id,
i1.Subject_From_Id
});
var subjectFrom = from s1 in dbContext.Subject
where s1.Id == ids.First().Subject_From_Id
select new
{
s1.Id,
s1.Name,
s1.Address,
s1.NIP,
s1.Bank,
s1.Bank_Account
};
var subjectFor = from s2 in dbContext.Subject
where s2.Id == ids.First().Subject_For_Id
select new
{
s2.Id,
s2.Name,
s2.Address,
s2.NIP,
s2.Bank,
s2.Bank_Account
};
Entity.ExtendedSubject[] subjects = new Entity.ExtendedSubject[2];
subjects[0] = new Entity.ExtendedSubject(
subjectFrom.First().Id,
subjectFrom.First().Name,
subjectFrom.First().Address,
subjectFrom.First().NIP,
subjectFrom.First().Bank,
subjectFrom.First().Bank_Account);
subjects[1] = new Entity.ExtendedSubject(
subjectFor.First().Id,
subjectFor.First().Name,
subjectFor.First().Address,
subjectFor.First().NIP,
subjectFor.First().Bank,
subjectFor.First().Bank_Account);
return(subjects);
}
public void AddSubject(Entity.ExtendedSubject subject)
{
Subject toInsert = new Subject();
toInsert.Id = GetFreeSubjectId();
toInsert.Name = subject.Name;
toInsert.Address = subject.Address;
toInsert.NIP = subject.NIP;
toInsert.Bank = subject.Bank;
toInsert.Bank_Account = subject.Bank_Account;
dbContext.Subject.InsertOnSubmit(toInsert);
dbContext.SubmitChanges();
}
public Entity.ExtendedSubject GetSubjectByName(String name)
{
Entity.ExtendedSubject toReturn = null;
foreach (Entity.ExtendedSubject s in GetSubjects())
{
if (s.Name.Equals(name))
{
toReturn = s;
}
}
return(toReturn);
}
