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); }