public void AddRequirement(ModelReqmnt newRequirement) { int nLastedId = -1; UDataQuerySet set = new UDataQuerySet("SP_REQ_INSERT", CommandType.StoredProcedure); set.AddParam("@PRJID", newRequirement.ProjectId); set.AddParam("@CATID", newRequirement.CategoryId); set.AddParam("@IDX", newRequirement.Index); set.AddParam("@SRCID", newRequirement.SourceId); set.AddParam("@REQNMT", newRequirement.Requirement.Trim()); try { nLastedId = m_agent.GetValue <int>(set); newRequirement.Id = nLastedId; foreach (ModelRemark remark in newRequirement.AllRemark) { remark.RequirementId = newRequirement.Id; AddRemark(remark); } } catch (Exception ex) { log.Error(ex); newRequirement.Id = -1; } }
private void gridItems_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e) { if (e.RowIndex > -1) { gridItems.Rows[e.RowIndex].Selected = true; DataRowView row = (DataRowView)gridItems.Rows[e.RowIndex].DataBoundItem; m_selectedRequirement = row["SRC"] as ModelReqmnt; } }
internal void AddRemark(ModelReqmnt curReq, string sContents) { ModelRemark remark = new ModelRemark(); remark.ProjectId = curReq.ProjectId; remark.RequirementId = curReq.Id; remark.Contents = sContents; curReq.AllRemark.Add(remark); DacFactory.Current.Requiremnt.AddRemark(remark); }
private void btnNext_Click(object sender, EventArgs e) { int nIndex = DataManager.Current.Requirement.SelectedRequirements.IndexOf(CurRequirement) + 1; if (nIndex >= DataManager.Current.Requirement.SelectedRequirements.Count) { nIndex = 0; } CurRequirement = DataManager.Current.Requirement.SelectedRequirements[nIndex]; Init(); }
internal List <ModelReqmnt> GetAllRequirements(ModelProject selectedProject, List <ModelCategory> aryAllCategory) { List <ModelReqmnt> aryResult = new List <ModelReqmnt>(); DataTable tbResult = null; DataTable tbResultRemark = null; UDataQuerySet set = new UDataQuerySet("SP_REQ_SELECT", CommandType.StoredProcedure); set.AddParam("@PRJID", selectedProject.ID); UDataQuerySet setRemark = new UDataQuerySet("SP_REQ_REMARK_SELECT", CommandType.StoredProcedure); setRemark.AddParam("@PRJID", selectedProject.ID); try { tbResult = m_agent.GetDataTable(set); tbResultRemark = m_agent.GetDataTable(setRemark); foreach (DataRow row in tbResult.Rows) { ModelReqmnt req = new ModelReqmnt(); req.WriteData(row); req.Category = aryAllCategory.Find(m => m.Id == req.CategoryIdFromDB); aryResult.Add(req); DataRow[] aryRemarks = tbResultRemark.Select(string.Format("REQID = {0}", req.Id)); foreach (DataRow rowRemark in aryRemarks) { ModelRemark remark = new ModelRemark(); remark.WriteData(rowRemark); req.AllRemark.Add(remark); } } } catch (Exception ex) { log.Error(ex); } finally { if (tbResult != null) { tbResult.Dispose(); } if (tbResultRemark != null) { tbResultRemark.Dispose(); } } return(aryResult); }
internal void Save(ModelReqmnt SelectedRequirement) { if (SelectedRequirement.Id == -1) { DacFactory.Current.Requiremnt.AddRequirement(SelectedRequirement); m_aryAllRequirements.Add(SelectedRequirement); SelectedRequirements.Add(SelectedRequirement); } else { DacFactory.Current.Requiremnt.UpdateRequirement(SelectedRequirement); } }
private void btnOKandNew_Click(object sender, EventArgs e) { int nSelectedIndex = cmbPath.SelectedIndex; ModelCategory category = (ModelCategory)cmbPath.Items[nSelectedIndex]; CurRequirement.Category = category; CurRequirement.Index = Convert.ToInt32(txtIndex.Text); CurRequirement.Requirement = txtRequirements.Text; DataManager.Current.Requirement.Save(CurRequirement); CurRequirement = null; Init(); }
internal void DelRequirement(ModelReqmnt selectedRequirement) { UDataQuerySet set = new UDataQuerySet("SP_REQ_DELETE", CommandType.StoredProcedure); set.AddParam("@ID", selectedRequirement.Id); try { m_agent.ExecuteQuery(set); } catch (Exception ex) { log.Error(ex); } }
public void UpdateRequirement(ModelReqmnt requirement) { UDataQuerySet set = new UDataQuerySet("SP_REQ_UPDATE", CommandType.StoredProcedure); set.AddParam("@ID", requirement.Id); set.AddParam("@CATID", requirement.CategoryId); set.AddParam("@IDX", requirement.Index); set.AddParam("@REQNMT", requirement.Requirement.Trim()); try { m_agent.ExecuteQuery(set); } catch (Exception ex) { log.Error(ex); } }
private void Init() { if (this.InvokeRequired) { this.Invoke(new MethodInvoker(Init)); } else { CollapsRemark(true); cmbPath.Enabled = false; ModelCategory selectedCategory = DataManager.Current.Category.SelectedCategory; cmbPath.DataSource = null; cmbPath.DataSource = DataManager.Current.Category.AllCategoryExceptRoot; cmbPath.DisplayMember = "PATH"; Category_OnSelectedCategoryChanged(selectedCategory); if (CurRequirement == null) { CurRequirement = DataManager.Current.Requirement.NewRequirement(); cmbPath.Enabled = true; txtIndex.Enabled = true; } ModelCategory category = DataManager.Current.Category.AllCategoryExceptRoot.Find(m => m.Id == CurRequirement.CategoryId); if (category == null) { category = DataManager.Current.Category.ETC; } if (category != null) { int nIndex = cmbPath.Items.IndexOf(category); cmbPath.SelectedIndex = nIndex; txtIndex.Text = Convert.ToString(CurRequirement.Index); txtRequirements.Text = CurRequirement.Requirement; listRemark.DataSource = CurRequirement.AllRemark; listRemark.DisplayMember = "Contents"; } } }
internal ModelReqmnt NewRequirement() { ModelReqmnt newReq = new ModelReqmnt(); if (m_parent != null && m_parent.SelectedProject != null) { int nMaxIndex = 0; foreach (ModelReqmnt req in SelectedRequirements) { if (req.Index > nMaxIndex) { nMaxIndex = req.Index; } } newReq.Id = -1; newReq.Index = nMaxIndex + 1; newReq.ProjectId = m_parent.SelectedProject.ID; newReq.Category = m_parent.Category.SelectedCategory; } return(newReq); }
internal void Delete(ModelReqmnt selectedRequirement) { DacFactory.Current.Requiremnt.DelRequirement(selectedRequirement); m_aryAllRequirements.Remove(selectedRequirement); SelectedRequirements.Remove(selectedRequirement); }
internal void DeleteRemark(ModelReqmnt curReq, ModelRemark selectedRemark) { DacFactory.Current.Requiremnt.DeleteRemark(selectedRemark); curReq.AllRemark.Remove(selectedRemark); }