public void SecretaryAddAResumé()
{
MettingSummery mettingSummery = new MettingSummery("Test", new Secretary("something", 1));
SummeryDataAccess summeryDataAccess = new SummeryDataAccess();
List <MettingSummery> resumés = summeryDataAccess.GetAllSummerysById();
summeryDataAccess.SafeSummery(mettingSummery);
List <MettingSummery> result = summeryDataAccess.GetAllSummerysById();
Assert.AreNotEqual(result.Count, resumés.Count);
}
public List <MettingSummery> GetAllSummerysById()
{
List <MettingSummery> mettingSummery = new List <MettingSummery>();
DataSet ds = Executor.Execute($"SELECT * FROM SelectSummerys");
foreach (DataRow dr in ds.Tables[0].Rows)
{
Secretary tempsec = new Secretary(dr.Field <string>("secretaryFullname"));
MettingSummery tempSum = new MettingSummery(dr.Field <string>("résume"), tempsec);
mettingSummery.Add(tempSum);
}
return(mettingSummery);
}
public List <Case> GetAllCase()
{
List <Case> cases = new List <Case>();
DataSet ds = Executor.Execute("SELECT * FROM GetAllCases");
foreach (DataRow dr in ds.Tables[0].Rows)
{
Client tempClient = new Client(dr.Field <string>("clientFullname"));
Lawyer tempLaw = new Lawyer(dr.Field <string>("LawyerFullname"));
Secretary tempsec = new Secretary(dr.Field <string>("secretaryFullname"));
CaseKind tempCaseK = (CaseKind)Enum.Parse(typeof(CaseKind), dr.Field <string>("caseKind"));
MettingSummery tempSum = new MettingSummery(dr.Field <string>("résume"), tempsec);
Case tempCase = new Case(dr.Field <string>("cases"), tempCaseK, tempLaw, tempClient, tempSum, dr.Field <int>("caseId"));
cases.Add(tempCase);
}
return(cases);
}
public void SafeSummery(MettingSummery summery)
{
Executor.Execute($"INSERT INTO Summery(CaseId, SecretaryId, résume) VALUES({1}, { summery.Secretary.Id}, '{ summery.Resumé}')");
}
