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