/// <summary> /// Handles the Click event of the btn_CritUpdate control. /// speichert den neuen Namen und Beschreibung in der DB ab sofern keine unerlaubten Zeichen vorkommen /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void btn_CritUpdate_Click(object sender, EventArgs e) { try { using (CriterionController CritUpdClick = new CriterionController()) { Criterion critUpd = CritUpdClick.GetCriterionById(Criterion.Criterion_Id); critUpd.Criterion_Id = this.Criterion.Criterion_Id; if (CommonMethods.CheckIfForbiddenDelimiterInDb(textBox_CritNameUpdate.Text) || CommonMethods.CheckIfForbiddenDelimiterInDb(textBox_CritDescUpdate.Text)) { MessageBox.Show(CommonMethods.MessageForbiddenDelimiterWasFoundInText()); } else { critUpd.Name = textBox_CritNameUpdate.Text; critUpd.Description = textBox_CritDescUpdate.Text; CritUpdClick.UpdateCriterionInDb(critUpd); this.Close(); } } } catch (Exception x) { MessageBox.Show(x.Message); } }
public Criterion_Show_View(Form parentView, int criterionId) { this.parentView = parentView; this.CriterionCont = new CriterionController(); this.Criterion = this.CriterionCont.GetCriterionById(criterionId); InitializeComponent(); }
/// <summary> /// Handles the Click event of the btn_CritDelete control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void btn_CritDelete_Click(object sender, EventArgs e) { try { DataGridViewRow row = dataGridView_Crits.SelectedRows[0]; int critId = (int)row.Cells[0].Value; using (CriterionController critDelete = new CriterionController()) { System.Windows.Forms.DialogResult result; if (critDelete.CheckIfCriterionIsAllocatedToAnyProject(critId)) { result = MessageBox.Show("Das Kriterium ist einem oder mehreren Projekten zugeordnet.\n" + "Wollen Sie das ausgeählte Kriterium wirklich löschen?", "Löschbestätigung", MessageBoxButtons.YesNo, MessageBoxIcon.Question); } else { result = MessageBox.Show("Wollen Sie das ausgeählte Kriterium wirklich löschen?", "Löschbestätigung", MessageBoxButtons.YesNo, MessageBoxIcon.Question); } if (result == DialogResult.Yes) { critDelete.DeleteCriterionFromDb(critId); RefreshList(); } } } catch (Exception x) { MessageBox.Show(x.Message); } }
/// <summary> /// insert or update /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertOrUpdate(object sender, DirectEventArgs e) { try { // init entity var model = new CriterionModel(); // check id if (!string.IsNullOrEmpty(hdfId.Text) && Convert.ToInt32(hdfId.Text) > 0) { var result = CriterionController.GetById(Convert.ToInt32(hdfId.Text));; if (result != null) { model = result; } } // set new props for entity model.Code = txtName.Text.ToUpperString(); model.ValueType = (KpiValueType)Enum.Parse(typeof(KpiValueType), hdfValueType.Text); model.Name = txtName.Text; model.Description = txtDescription.Text; model.Formula = txtFormula.Text; model.Order = !string.IsNullOrEmpty(txtOrder.Text) ? Convert.ToInt32(txtOrder.Text) : 0; model.Status = chkIsActive.Checked ? KpiStatus.Active : KpiStatus.Locked; model.FormulaRange = hdfFormulaRange.Text; // check entity id if (model.Id > 0) { model.EditedDate = DateTime.Now; model.EditedBy = CurrentUser.User.UserName; // update CriterionController.Update(model); } else { model.CreatedBy = CurrentUser.User.UserName; model.CreatedDate = DateTime.Now; model.EditedDate = DateTime.Now; model.EditedBy = ""; // insert CriterionController.Create(model); } // hide window wdSetting.Hide(); //reset form ResetForm(); // reload data gpCriterion.Reload(); } catch (Exception exception) { Dialog.ShowError(exception); } }
public Criterion_Update_View(Kriterienverwaltung_View parentView, int criterionId) { this.parentView = parentView; using (CriterionController CritUpdView = new CriterionController()) { this.Criterion = CritUpdView.GetCriterionById(criterionId); } InitializeComponent(); }
/// <summary> /// Allocates the new project criterion. /// </summary> /// <param name="projCritToAllocate">The proj crit to allocate.</param> /// <param name="index">The index.</param> /// Erstellt von Veit Berg, am 27.01.16 public void AllocateNewProjectCriterion(ProjectCriterion projCritToAllocate, int index) { try{ ProjCrits.Add(projCritToAllocate); projCritCont.ChangeAllocationOfProjectCriterionsInDb(ProjectId, ProjCrits); // AllCrits.Remove((Criterion)projCritToAllocate); //foreach (ProjectCriterion projCrit in ProjCrits) //{ // Criterion allocatedCrit = AllCrits.Single(crit => crit.Criterion_Id == projCrit.Criterion_Id); // AllCrits.Remove(allocatedCrit); //} using (CriterionController critCont = new CriterionController()) { AllCrits = critCont.GetAllCriterionsFromDb(); if (ProjCrits.Count != 0) { foreach (ProjectCriterion projCrit in ProjCrits) { Criterion allocatedCrit = AllCrits.Single(crit => crit.Criterion_Id == projCrit.Criterion_Id); AllCrits.Remove(allocatedCrit); } } } using (ProjectCriterionController proCriCont = new ProjectCriterionController()) { ProjCrits = proCriCont.GetAllProjectCriterionsForOneProject(ProjectId); } using (CriterionController critCont = new CriterionController()) { AllCrits = critCont.GetAllCriterionsFromDb(); if (ProjCrits.Count != 0) { foreach (ProjectCriterion projCrit in ProjCrits) { Criterion allocatedCrit = AllCrits.Single(crit => crit.Criterion_Id == projCrit.Criterion_Id); AllCrits.Remove(allocatedCrit); } } } dataGridView_CritAvail.DataSource = null; dataGridView_CritAvail.DataSource = AllCrits; refreshGridL(); } catch (Exception x) { MessageBox.Show(x.Message); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertEvaluationByGroup(object sender, DirectEventArgs e) { try { if (!string.IsNullOrEmpty(hdfGroupFilter.Text)) { var criterionModels = CriterionController.GetAll(null, Convert.ToInt32(hdfGroupFilter.Text), false, KpiStatus.Active, null, null, null); //create new all employee var records = RecordController.GetAll(null, null, DepartmentIds, RecordType.Default, null, null); foreach (var criterion in criterionModels) { foreach (var item in records) { var model = new EvaluationModel() { RecordId = item.Id, CriterionId = criterion.Id, Month = DateTime.Now.Month, Year = DateTime.Now.Year, Value = "" }; //get value GetValueCriterionWorkbook(model, criterion, Convert.ToInt32(hdfGroupFilter.Text)); //check exist var evaluation = EvaluationController.CheckExist(model.RecordId, model.CriterionId, model.Month, model.Year); if (evaluation != null) { model.Id = evaluation.Id; //update EvaluationController.Update(model); } else { //create EvaluationController.Create(model); } } } //hide window wdEvaluation.Hide(); // reload grid gpEvaluation.Reload(); } } catch (Exception exception) { Dialog.ShowError(exception); } }
/// <summary> /// init setting window /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InitWindow(object sender, DirectEventArgs e) { try { //reset form ResetForm(); // init window props if (e.ExtraParams["Command"] == "Update") { // edit wdSetting.Title = @"Cập nhật tiêu chí đánh giá"; wdSetting.Icon = Icon.Pencil; var model = CriterionController.GetById(Convert.ToInt32(hdfId.Text)); if (model != null) { // set props txtCode.Text = model.Code; txtFormula.Text = model.Formula; txtOrder.Text = model.Order.ToString(); cboValueType.Text = model.ValueTypeName; hdfValueType.Text = ((int)model.ValueType).ToString(); txtName.Text = model.Name; txtDescription.Text = model.Description; if (model.Status == KpiStatus.Active) { chkIsActive.Checked = true; } hdfFormulaRange.Text = model.FormulaRange; } } else { // insert wdSetting.Title = @"Thêm mới tiêu chí đánh giá"; wdSetting.Icon = Icon.Add; } // show window wdSetting.Show(); } catch (Exception exception) { Dialog.ShowError(exception); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void EvaluationClick(object sender, DirectEventArgs e) { try { if (!string.IsNullOrEmpty(hdfId.Text)) { //create new all employee var records = RecordController.GetAll(null, null, DepartmentIds, RecordType.Default, null, null); var criterion = CriterionController.GetById(Convert.ToInt32(hdfId.Text)); foreach (var item in records) { var model = new EvaluationModel() { RecordId = item.Id, CriterionId = Convert.ToInt32(hdfId.Text), Month = DateTime.Now.Month, Year = DateTime.Now.Year, Value = "" }; //get value GetValueCriterionWorkbook(model, criterion, null); //check exist var evaluation = EvaluationController.CheckExist(model.RecordId, model.CriterionId, model.Month, model.Year); if (evaluation != null) { model.Id = evaluation.Id; //update EvaluationController.Update(model); } else { //create EvaluationController.Create(model); } } } } catch (Exception exception) { Dialog.ShowError(exception); } }
/// <summary> /// Handles the Click event of the btn_CritShow control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void btn_CritShow_Click(object sender, EventArgs e) { try{ using (CriterionController critShow = new CriterionController()) { DataGridViewRow row = dataGridView_Crits.SelectedRows[0]; int zelle1 = (int)row.Cells[0].Value; string zelle2 = (string)row.Cells[1].Value; string zelle3 = (string)row.Cells[2].Value; Criterion_Show_View CritShowView = new Criterion_Show_View(this, zelle1); CritShowView.Show(); } } catch (Exception x) { MessageBox.Show(x.Message); } }
/// <summary> /// Handles the Click event of the btn_CritToPool control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void btn_CritToPool_Click(object sender, EventArgs e) { try{ if ((int)dataGridView_ProjCrits.SelectedRows[0].Index >= 0) { DataGridViewRow row = dataGridView_ProjCrits.SelectedRows[0]; int CritId = (int)row.Cells["Criterion_Id"].Value; int index = dataGridView_ProjCrits.CurrentCell.RowIndex; ProjCrits.RemoveAt(index); projCritCont.ChangeAllocationOfProjectCriterionsInDb(ProjectId, ProjCrits); using (ProjectCriterionController proCriCont = new ProjectCriterionController()) { ProjCrits = proCriCont.GetAllProjectCriterionsForOneProject(ProjectId); } using (CriterionController critCont = new CriterionController()) { AllCrits = critCont.GetAllCriterionsFromDb(); if (ProjCrits.Count != 0) { foreach (ProjectCriterion projCrit in ProjCrits) { Criterion allocatedCrit = AllCrits.Single(crit => crit.Criterion_Id == projCrit.Criterion_Id); AllCrits.Remove(allocatedCrit); } } } dataGridView_CritAvail.DataSource = null; dataGridView_CritAvail.DataSource = AllCrits; refreshGridL(); } else { MessageBox.Show("Bitte erst eine Zeile auswählen"); } } catch (Exception x) { MessageBox.Show(x.Message); } }
/// <summary> /// Delete /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Delete(object sender, DirectEventArgs e) { try { if (!string.IsNullOrEmpty(hdfId.Text)) { //delete CriterionController.Delete(Convert.ToInt32(hdfId.Text)); //delete criterion in group CriterionGroupController.DeleteByCondition(null, Convert.ToInt32(hdfId.Text)); } // reload data gpCriterion.Reload(); } catch (Exception exception) { Dialog.ShowError(exception); } }
/// <summary> /// Refreshes the list. /// für manuelles Refreshen /// </summary> /// Erstellt von Veit Berg, am 27.01.16 public void RefreshList() { //List<Criterion> CritList = critCont.GetAllCriterionsFromDb(); //var bindingList = new BindingList<Criterion>(CritList); //var source = new BindingSource(bindingList, null); //dataGridView_Crits.DataSource = CritList; try { using (CriterionController CritRefr = new CriterionController()) { List <Criterion> CritList = CritRefr.GetAllCriterionsFromDb(); var bindingList = new BindingList <Criterion>(CritList); var source = new BindingSource(bindingList, null); dataGridView_Crits.DataSource = CritList; } } catch (Exception x) { MessageBox.Show(x.Message); } }
/// <summary> /// Handles the Load event of the ProjCritParentAllocation control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void ProjCritParentAllocation_Load(object sender, EventArgs e) { try{ List <Criterion> allocCrits = new List <Criterion>(); using (CriterionController critCont = new CriterionController()) { foreach (ProjectCriterion projCrit in AllAllocProjCrits) { Criterion addCrit = critCont.GetCriterionById(projCrit.Criterion_Id); allocCrits.Add(addCrit); } } comboBox_CritName.DataSource = allocCrits; comboBox_CritName.DisplayMember = "Name"; } catch (Exception i) { MessageBox.Show(i.Message); } }
public Criterion_Create_View(Kriterienverwaltung_View parentView) { this.parentView = parentView; this.critCont = new CriterionController(); InitializeComponent(); }
/// <summary> /// Handles the Load event of the ProjCritAssign_Form control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void ProjCritAssign_Form_Load(object sender, EventArgs e) { try{ using (ProjectCriterionController proCriCont = new ProjectCriterionController()) { ProjCrits = proCriCont.GetAllProjectCriterionsForOneProject(ProjectId); } using (CriterionController critCont = new CriterionController()) { AllCrits = critCont.GetAllCriterionsFromDb(); if (ProjCrits.Count != 0) { foreach (ProjectCriterion projCrit in ProjCrits) { Criterion allocatedCrit = AllCrits.Single(crit => crit.Criterion_Id == projCrit.Criterion_Id); AllCrits.Remove(allocatedCrit); } } } dataGridView_CritAvail.Rows.Clear(); var CritBindingList = new BindingList <Criterion>(AllCrits); var CritSource = new BindingSource(CritBindingList, null); dataGridView_CritAvail.DataSource = AllCrits; dataGridView_CritAvail.Columns[0].HeaderText = "ID"; dataGridView_CritAvail.Columns[0].Width = 30; dataGridView_CritAvail.Columns[1].Width = 200; dataGridView_CritAvail.Columns[2].Width = 240; dataGridView_CritAvail.Columns["Description"].HeaderText = "Beschreibung"; dataGridView_CritAvail.Columns[0].ReadOnly = true; dataGridView_CritAvail.Columns[1].ReadOnly = true; dataGridView_CritAvail.Columns[2].ReadOnly = true; dataGridView_ProjCrits.Rows.Clear(); using (CriterionController critCon = new CriterionController()) { foreach (ProjectCriterion projCrit in ProjCrits) { var singleCritId = critCon.GetCriterionById(projCrit.Criterion_Id); projCrit.Name = singleCritId.Name.ToString(); } } var ProjCritBindingList = new BindingList <ProjectCriterion>(ProjCrits); var projCritSource = new BindingSource(ProjCritBindingList, null); dataGridView_ProjCrits.DataSource = ProjCrits; dataGridView_ProjCrits.Columns.Remove("Project_Id"); dataGridView_ProjCrits.Columns.Remove("Layer_Depth"); dataGridView_ProjCrits.Columns.Remove("Weighting_Cardinal"); dataGridView_ProjCrits.Columns.Remove("Weighting_Percentage_Layer"); dataGridView_ProjCrits.Columns.Remove("Weighting_Percentage_Project"); dataGridView_ProjCrits.Columns.Remove("Criterion"); dataGridView_ProjCrits.Columns.Remove("ParentCriterion"); dataGridView_ProjCrits.Columns.Remove("Project"); dataGridView_ProjCrits.Columns.Add("Beschreibung", "Beschreibung"); int i = 0; foreach (ProjectCriterion ProCri in ProjCrits) { dataGridView_ProjCrits["Beschreibung", i].Value = ProCri.Criterion.Description; i++; } dataGridView_ProjCrits.Columns[0].HeaderText = "ID"; dataGridView_ProjCrits.Columns[0].Width = 40; dataGridView_ProjCrits.Columns[1].HeaderText = "P-ID"; dataGridView_ProjCrits.Columns[1].Width = 40; dataGridView_ProjCrits.Columns[2].Width = 200; dataGridView_ProjCrits.Columns[3].Width = 190; dataGridView_ProjCrits.Columns[0].ReadOnly = true; dataGridView_ProjCrits.Columns[1].ReadOnly = true; dataGridView_ProjCrits.Columns[2].ReadOnly = true; dataGridView_ProjCrits.Columns[3].ReadOnly = true; this.FormClosing += new FormClosingEventHandler(ProjCritAssign_View_FormClosing); } catch (Exception i) { MessageBox.Show(i.Message); } }
/// <summary> /// Refreshes the grid l. /// </summary> /// Erstellt von Veit Berg, am 27.01.16 private void refreshGridL() { try{ dataGridView_CritAvail.Columns["Criterion_Id"].HeaderText = "ID"; dataGridView_CritAvail.Columns["Criterion_Id"].Width = 30; dataGridView_CritAvail.Columns["Criterion_Id"].DisplayIndex = 0; dataGridView_CritAvail.Columns["Criterion_Id"].ReadOnly = true; dataGridView_CritAvail.Columns["Name"].HeaderText = "Name"; dataGridView_CritAvail.Columns["Name"].Width = 200; dataGridView_CritAvail.Columns["Name"].DisplayIndex = 1; dataGridView_CritAvail.Columns["Name"].ReadOnly = true; dataGridView_CritAvail.Columns["Description"].HeaderText = "Beschreibung"; dataGridView_CritAvail.Columns["Description"].Width = 240; dataGridView_CritAvail.Columns["Description"].DisplayIndex = 2; dataGridView_CritAvail.Columns["Description"].ReadOnly = true; dataGridView_ProjCrits.DataSource = null; using (ProjectCriterionController proCriCon = new ProjectCriterionController()) { ProjCrits = proCriCon.GetAllProjectCriterionsForOneProject(ProjectId); } using (CriterionController critCon = new CriterionController()) { foreach (ProjectCriterion projCrit in ProjCrits) { var singleCritId = critCon.GetCriterionById(projCrit.Criterion_Id); projCrit.Name = singleCritId.Name.ToString(); } } dataGridView_ProjCrits.DataSource = ProjCrits; dataGridView_ProjCrits.Columns.Remove("Project_Id"); dataGridView_ProjCrits.Columns.Remove("Layer_Depth"); dataGridView_ProjCrits.Columns.Remove("Weighting_Cardinal"); dataGridView_ProjCrits.Columns.Remove("Weighting_Percentage_Layer"); dataGridView_ProjCrits.Columns.Remove("Weighting_Percentage_Project"); dataGridView_ProjCrits.Columns.Remove("Criterion"); dataGridView_ProjCrits.Columns.Remove("ParentCriterion"); dataGridView_ProjCrits.Columns.Remove("Project"); int i = 0; foreach (ProjectCriterion ProCri in ProjCrits) { dataGridView_ProjCrits["Beschreibung", i].Value = ProCri.Criterion.Description; i++; } //dataGridView_ProjCrits.Columns["Criterion_Id"].HeaderText = "ID"; //dataGridView_ProjCrits.Columns["Name"].HeaderText = "Name"; //dataGridView_ProjCrits.Columns["Description"].HeaderText = "Beschreibung"; //dataGridView_ProjCrits.Columns["Criterion_Id"].DisplayIndex = 0; //dataGridView_ProjCrits.Columns["Name"].DisplayIndex = 1; //dataGridView_ProjCrits.Columns["Description"].DisplayIndex = 2; dataGridView_ProjCrits.Columns[0].DisplayIndex = 3; dataGridView_ProjCrits.Columns[1].HeaderText = "ID"; dataGridView_ProjCrits.Columns[1].Width = 40; dataGridView_ProjCrits.Columns[2].HeaderText = "P-ID"; dataGridView_ProjCrits.Columns[2].Width = 40; dataGridView_ProjCrits.Columns[3].Width = 200; dataGridView_ProjCrits.Columns[0].ReadOnly = true; dataGridView_ProjCrits.Columns[1].ReadOnly = true; dataGridView_ProjCrits.Columns[2].ReadOnly = true; dataGridView_ProjCrits.Columns[3].ReadOnly = true; //dataGridView_ProjCrits.Columns["Criterion_Id"].Width = 40; //dataGridView_ProjCrits.Columns["Name"].Width = 100; //dataGridView_ProjCrits.Columns["Description"].Width = 200; } catch (Exception x) { MessageBox.Show(x.Message); } }
/// <summary> /// Handles the Load event of the ProjCritStruUpdate_Form control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void ProjCritStruUpdate_Form_Load(object sender, EventArgs e) { try{ using (ProjectCriterionController proCriCont = new ProjectCriterionController()) { ProjCrits = proCriCont.GetSortedCriterionStructure(ProjectId); using (CriterionController critCon = new CriterionController()) { foreach (ProjectCriterion projCrit in ProjCrits) { var singleCritId = critCon.GetCriterionById(projCrit.Criterion_Id); projCrit.Name = singleCritId.Name.ToString(); } } var CritBindingList = new BindingList <ProjectCriterion>(ProjCrits); this.CritSource = new BindingSource(CritBindingList, null); dataGridView_CritStruUpd.DataSource = ProjCrits; dataGridView_CritStruUpd.Columns.Remove("Project_Id"); dataGridView_CritStruUpd.Columns.Remove("Criterion"); dataGridView_CritStruUpd.Columns.Remove("ParentCriterion"); dataGridView_CritStruUpd.Columns.Remove("Project"); dataGridView_CritStruUpd.Columns[0].ReadOnly = true; dataGridView_CritStruUpd.Columns[0].Width = 40; dataGridView_CritStruUpd.Columns[1].ReadOnly = true; dataGridView_CritStruUpd.Columns[1].HeaderText = "Layer"; dataGridView_CritStruUpd.Columns[1].Width = 40; dataGridView_CritStruUpd.Columns[2].HeaderText = "P-ID"; dataGridView_CritStruUpd.Columns[2].Width = 40; dataGridView_CritStruUpd.Columns[3].ReadOnly = true; dataGridView_CritStruUpd.Columns[3].HeaderText = "W(C)"; dataGridView_CritStruUpd.Columns[4].ReadOnly = true; dataGridView_CritStruUpd.Columns[4].HeaderText = "W(PL)"; dataGridView_CritStruUpd.Columns[5].ReadOnly = true; dataGridView_CritStruUpd.Columns[5].HeaderText = "W(PP)"; dataGridView_CritStruUpd.Columns["Weighting_Percentage_Project"].Width = 40; dataGridView_CritStruUpd.Columns[6].ReadOnly = true; dataGridView_CritStruUpd.Columns[6].HeaderText = "Name"; dataGridView_CritStruUpd.Columns.Add("Beschreibung", "Beschreibung"); dataGridView_CritStruUpd.Columns["Beschreibung"].ReadOnly = true; int i = 0; foreach (ProjectCriterion ProCri in ProjCrits) { dataGridView_CritStruUpd["Beschreibung", i].Value = ProCri.Criterion.Description; i++; } dataGridView_CritStruUpd.Columns[1].DisplayIndex = 0; dataGridView_CritStruUpd.Columns[2].DisplayIndex = 1; dataGridView_CritStruUpd.Columns[6].DisplayIndex = 3; dataGridView_CritStruUpd.Columns[6].Width = 200; dataGridView_CritStruUpd.Columns[7].DisplayIndex = 4; dataGridView_CritStruUpd.Columns[7].Width = 200; dataGridView_CritStruUpd.Columns["Criterion_Id"].HeaderText = "ID"; dataGridView_CritStruUpd.Columns["Name"].ReadOnly = true; dataGridView_CritStruUpd.Columns["Weighting_Percentage_Project"].Width = 100; dataGridView_CritStruUpd.Show(); } this.dataGridView_CritStruUpd.CellValidating += new DataGridViewCellValidatingEventHandler(dataGridView_CritStruUpd_CellValidating); this.FormClosing += new FormClosingEventHandler(ProjCritStruUpdate_View_FormClosing); } catch (Exception i) { MessageBox.Show(i.Message); } }
/// <summary> /// Refreshes the grid. /// </summary> /// Erstellt von Veit Berg, am 27.01.16 private void refreshGrid() { try{ dataGridView_ProjCritBalance.DataSource = null; using (ProjectCriterionController proCriCont = new ProjectCriterionController()) { ProjCrits = proCriCont.GetSortedCriterionStructure(ProjectId); using (CriterionController critCon = new CriterionController()) { foreach (ProjectCriterion projCrit in ProjCrits) { var singleCritId = critCon.GetCriterionById(projCrit.Criterion_Id); projCrit.Name = singleCritId.Name.ToString(); } } var CritBindingList = new BindingList <ProjectCriterion>(ProjCrits); var CritSource = new BindingSource(CritBindingList, null); dataGridView_ProjCritBalance.DataSource = ProjCrits; dataGridView_ProjCritBalance.Columns.Remove("Project_Id"); dataGridView_ProjCritBalance.Columns.Remove("Criterion"); dataGridView_ProjCritBalance.Columns.Remove("ParentCriterion"); dataGridView_ProjCritBalance.Columns.Remove("Project"); int i = 0; foreach (ProjectCriterion ProCri in ProjCrits) { dataGridView_ProjCritBalance["Beschreibung1", i].Value = ProCri.Criterion.Description; i++; } dataGridView_ProjCritBalance.Columns["Criterion_Id"].HeaderText = "ID"; dataGridView_ProjCritBalance.Columns[1].Width = 40; dataGridView_ProjCritBalance.Columns[1].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Parent_Criterion_Id"].HeaderText = "P-ID"; dataGridView_ProjCritBalance.Columns[2].Width = 40; dataGridView_ProjCritBalance.Columns[2].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Weighting_Cardinal"].HeaderText = "G(C)"; dataGridView_ProjCritBalance.Columns["Weighting_Cardinal"].Width = 40; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Layer"].HeaderText = "G(PL)"; dataGridView_ProjCritBalance.Columns["Criterion_Id"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Weighting_Cardinal"].Width = 40; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Layer"].Width = 100; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].Width = 100; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].HeaderText = "G(PP)"; dataGridView_ProjCritBalance.Columns[5].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Layer_Depth"].HeaderText = "Layer"; dataGridView_ProjCritBalance.Columns["Layer_Depth"].DisplayIndex = 0; dataGridView_ProjCritBalance.Columns["Layer_Depth"].Width = 50; dataGridView_ProjCritBalance.Columns["Criterion_Id"].DisplayIndex = 1; dataGridView_ProjCritBalance.Columns["Parent_Criterion_Id"].DisplayIndex = 2; dataGridView_ProjCritBalance.Columns["Weighting_Cardinal"].DisplayIndex = 3; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Layer"].DisplayIndex = 4; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].DisplayIndex = 5; dataGridView_ProjCritBalance.Columns["Name"].DisplayIndex = 6; dataGridView_ProjCritBalance.Columns["Name"].Width = 150; dataGridView_ProjCritBalance.Columns["Beschreibung1"].DisplayIndex = 7; dataGridView_ProjCritBalance.Columns["Beschreibung1"].Width = 350; dataGridView_ProjCritBalance.Columns["Parent_Criterion_Id"].Width = 40; dataGridView_ProjCritBalance.Columns["Beschreibung1"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Name"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Criterion_Id"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Parent_Criterion_Id"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].ReadOnly = true; } } catch (Exception x) { MessageBox.Show(x.Message); } }
/// <summary> /// Handles the Load event of the ProjCritBalance_View control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void ProjCritBalance_View_Load(object sender, EventArgs e) { try { using (ProjectCriterionController proCriCont = new ProjectCriterionController()) { ProjCrits = proCriCont.GetSortedCriterionStructure(ProjectId); using (CriterionController critCon = new CriterionController()) { foreach (ProjectCriterion projCrit in ProjCrits) { var singleCritId = critCon.GetCriterionById(projCrit.Criterion_Id); projCrit.Name = singleCritId.Name.ToString(); } } dataGridView_ProjCritBalance.Rows.Clear(); var CritBindingList = new BindingList <ProjectCriterion>(ProjCrits); var CritSource = new BindingSource(CritBindingList, null); dataGridView_ProjCritBalance.DataSource = ProjCrits; dataGridView_ProjCritBalance.Columns.Remove("Project_Id"); dataGridView_ProjCritBalance.Columns.Remove("Strukture"); dataGridView_ProjCritBalance.Columns.Remove("Criterion"); dataGridView_ProjCritBalance.Columns.Remove("ParentCriterion"); dataGridView_ProjCritBalance.Columns.Remove("Project"); dataGridView_ProjCritBalance.Columns.Add("Beschreibung1", "Beschreibung"); int i = 0; foreach (ProjectCriterion ProCri in ProjCrits) { dataGridView_ProjCritBalance["Beschreibung1", i].Value = ProCri.Criterion.Description; i++; } dataGridView_ProjCritBalance.Columns["Name"].Width = 150; dataGridView_ProjCritBalance.Columns["Criterion_ID"].HeaderText = "ID"; dataGridView_ProjCritBalance.Columns["Criterion_ID"].Width = 40; dataGridView_ProjCritBalance.Columns["Layer_Depth"].DisplayIndex = 0; dataGridView_ProjCritBalance.Columns["Layer_Depth"].HeaderText = "Layer"; dataGridView_ProjCritBalance.Columns[1].Width = 40; dataGridView_ProjCritBalance.Columns[1].ReadOnly = true; dataGridView_ProjCritBalance.Columns[2].HeaderText = "P-ID"; dataGridView_ProjCritBalance.Columns[2].Width = 40; dataGridView_ProjCritBalance.Columns[2].ReadOnly = true; dataGridView_ProjCritBalance.Columns[3].HeaderText = "G(C)"; dataGridView_ProjCritBalance.Columns[3].Width = 40; dataGridView_ProjCritBalance.Columns["Parent_Criterion_Id"].Width = 40; dataGridView_ProjCritBalance.Columns[4].HeaderText = "G(PL)"; dataGridView_ProjCritBalance.Columns[4].Width = 100; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].HeaderText = "G(PP)"; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].Width = 100; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].DisplayIndex = 5; dataGridView_ProjCritBalance.Columns["Weighting_Percentage_Project"].ReadOnly = true; dataGridView_ProjCritBalance.Columns[4].ReadOnly = true; dataGridView_ProjCritBalance.Columns[5].ReadOnly = true; dataGridView_ProjCritBalance.Columns[5].Width = 100; dataGridView_ProjCritBalance.Columns["Beschreibung1"].DisplayIndex = 7; dataGridView_ProjCritBalance.Columns["Beschreibung1"].Width = 350; dataGridView_ProjCritBalance.Columns["Layer_Depth"].Width = 50; dataGridView_ProjCritBalance.Columns["Beschreibung1"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Name"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Criterion_Id"].ReadOnly = true; dataGridView_ProjCritBalance.Columns["Parent_Criterion_Id"].ReadOnly = true; } } catch (FormatException) { MessageBox.Show("Bitte nur Zahlen eingeben"); } this.dataGridView_ProjCritBalance.CellValidating += new DataGridViewCellValidatingEventHandler(dataGridView_ProjCritBalance_CellValidating); this.FormClosing += new FormClosingEventHandler(ProjCritBalance_View_FormClosing); }
/// <summary> /// Handles the Load event of the ProjCritProdFulfilment_Form control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void ProjCritProdFulfilment_Form_Load(object sender, EventArgs e) { try{ formloaded = 1; using (ProjectProductController Projverw = new ProjectProductController()) { ProjectProduct projprod = (ProjectProduct)comboBox_ProjCritProdFulf.SelectedItem; List <ProjectProduct> ProdList = Projverw.GetAllProjectProductsForOneProject(Project.Project_Id); List <Product> productsList = new List <Product>(); foreach (ProjectProduct projProd in ProdList) { productsList.Add(projProd.Product); } comboBox_ProjCritProdFulf.DataSource = productsList; comboBox_ProjCritProdFulf.DisplayMember = "Name"; comboBox_ProjCritProdFulf.SelectedIndex = -1; } using (ProjectCriterionController proCriCont = new ProjectCriterionController()) { ProjCrits = proCriCont.GetSortedCriterionStructure(Project.Project_Id); using (CriterionController critCon = new CriterionController()) { foreach (ProjectCriterion projCrit in ProjCrits) { var singleCritId = critCon.GetCriterionById(projCrit.Criterion_Id); projCrit.Name = singleCritId.Name.ToString(); } } var CritBindingList = new BindingList <ProjectCriterion>(ProjCrits); var CritSource = new BindingSource(CritBindingList, null); dataGridView_ProjCritProdFulf.DataSource = ProjCrits; dataGridView_ProjCritProdFulf.Columns.Remove("Project_Id"); dataGridView_ProjCritProdFulf.Columns.Remove("Weighting_Cardinal"); dataGridView_ProjCritProdFulf.Columns.Remove("Weighting_Percentage_Layer"); dataGridView_ProjCritProdFulf.Columns.Remove("Weighting_Percentage_Project"); dataGridView_ProjCritProdFulf.Columns.Remove("Criterion"); dataGridView_ProjCritProdFulf.Columns.Remove("ParentCriterion"); dataGridView_ProjCritProdFulf.Columns.Remove("Project"); DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn(); dataGridView_ProjCritProdFulf.Columns.Add(chk); chk.Name = "Erfüllung"; DataGridViewTextBoxColumn bem = new DataGridViewTextBoxColumn(); bem.Name = "Bemerkung"; dataGridView_ProjCritProdFulf.Columns.Add(bem); dataGridView_ProjCritProdFulf.Columns[4].DisplayIndex = 0; dataGridView_ProjCritProdFulf.Columns[3].DisplayIndex = 1; dataGridView_ProjCritProdFulf.Columns[5].DisplayIndex = 2; dataGridView_ProjCritProdFulf.Columns[1].DisplayIndex = 3; dataGridView_ProjCritProdFulf.Columns[0].DisplayIndex = 4; dataGridView_ProjCritProdFulf.Columns[2].DisplayIndex = 5; dataGridView_ProjCritProdFulf.Columns[0].HeaderText = "C-ID"; dataGridView_ProjCritProdFulf.Columns[1].HeaderText = "Layer"; dataGridView_ProjCritProdFulf.Columns[2].HeaderText = "P-ID"; dataGridView_ProjCritProdFulf.Columns[3].HeaderText = "Name"; dataGridView_ProjCritProdFulf.Columns[4].Name = "Erfüllung"; dataGridView_ProjCritProdFulf.Columns["Name"].ReadOnly = true; dataGridView_ProjCritProdFulf.Columns["Layer_Depth"].ReadOnly = true; dataGridView_ProjCritProdFulf.Columns["Criterion_ID"].ReadOnly = true; dataGridView_ProjCritProdFulf.Columns["Parent_Criterion_Id"].ReadOnly = true; dataGridView_ProjCritProdFulf.Columns[0].Width = 50; dataGridView_ProjCritProdFulf.Columns[1].Width = 50; dataGridView_ProjCritProdFulf.Columns[2].Width = 50; dataGridView_ProjCritProdFulf.Columns[4].Width = 50; dataGridView_ProjCritProdFulf.Columns[3].Width = 150; dataGridView_ProjCritProdFulf.Columns[5].Width = 200; foreach (DataGridViewRow row in dataGridView_ProjCritProdFulf.Rows) { row.Cells["Erfüllung"].Value = false; } } } catch (Exception i) { MessageBox.Show(i.Message); } this.dataGridView_ProjCritProdFulf.CellValidating += new DataGridViewCellValidatingEventHandler(dataGridView_ProjCritProdFulf_CellValidating); this.FormClosing += new FormClosingEventHandler(ProjCritProdFulfillment_View_FormClosing); }