private async Task <int> UpdateSubjectAsync(dlgObsada dlg, SubjectSchemeModel P)
{
using (var scope = AppSession.TypeContainer.BeginLifetimeScope())
{
var dbs = scope.Resolve <IDataBaseService>();
return(await dbs.UpdateRecordAsync(SubjectSchemeSQL.UpdateScheme(), CreateUpdateParams(dlg, P)));
}
}
IDictionary <string, object> CreateUpdateParams(dlgObsada dlg, SubjectSchemeModel p)
{
var sqlParamWithValue = new Dictionary <string, object>();
sqlParamWithValue.Add("@ID", p.ID);
sqlParamWithValue.Add("@Grupa", dlg.chkGrupa.Checked);
sqlParamWithValue.Add("@Kategoria", dlg.chkKategoria.Checked ? "o" : "n");
sqlParamWithValue.Add("@Avg", dlg.chkAvg.Checked);
sqlParamWithValue.Add("@DataAktywacji", dlg.dtStartDate.Value);
sqlParamWithValue.Add("@DataDeaktywacji", dlg.dtEndDate.Value);
sqlParamWithValue.Add("@LiczbaGodzin", dlg.nudLiczbaGodzin.Value);
sqlParamWithValue.Add("@User", UserSession.User.Login);
sqlParamWithValue.Add("@IP", AppSession.HostIP);
return(sqlParamWithValue);
}
private void FillDialog(dlgObsada dlg, SubjectSchemeModel P)
{
dlg.Text = "Edycja danych";
dlg.cbKlasa.Enabled = false;
dlg.cbPrzedmiot.Enabled = false;
dlg.chkPion.Enabled = false;
dlg.cbKlasa.Items.Add(P.ClassName);
dlg.cbKlasa.SelectedIndex = 0;
dlg.cbPrzedmiot.Items.Add(P.SubjectName);
dlg.cbPrzedmiot.SelectedIndex = 0;
dlg.chkAvg.Checked = P.ToAvg > 0;
dlg.chkGrupa.Checked = P.Group > 0;
dlg.chkKategoria.Checked = P.SubjectCategory == "o" ? true : false;
dlg.dtStartDate.Value = P.StartDate;
dlg.dtEndDate.Value = P.EndDate;
dlg.nudLiczbaGodzin.Value = (decimal)P.LessonCount;
dlg.cmdOK.Enabled = true;
}
private void PrintObjectData(SubjectSchemeModel Node, float x, ref float y, List <TableCellWithAlignment> PrintCol, Font PrintFont, float LineHeight)
{
List <string> AspectToPrint = new List <string>();
AspectToPrint.Add(Node.ClassName);
AspectToPrint.Add(Node.SubjectName);
AspectToPrint.Add(Node.Group.ToString());
AspectToPrint.Add(Node.SubjectCategory);
AspectToPrint.Add(Node.ToAvg.ToString());
AspectToPrint.Add(Node.StartDate.ToShortDateString());
AspectToPrint.Add(Node.EndDate.ToShortDateString());
AspectToPrint.Add(Node.LessonCount.ToString());
for (int i = 0; i < AspectToPrint.Count; i++)
{
PH.DrawText(AspectToPrint[i], PrintFont, x, y, PrintCol[i].Size, LineHeight, PrintCol[i].Alignment, Brushes.Black, false, false);
x += PrintCol[i].Size;
}
y += LineHeight;
}
private void GetSignature(SubjectSchemeModel UserItem)
{
lblData.Text = UserItem.Creator.Version.ToString();
lblIP.Text = UserItem.Creator.IP;
lblUser.Text = UserItem.Creator.ToString();
}
