internal static void AddRemark(Remark remark) { using (var conn = new SqlConnection(connectionString)) { conn.Open(); remark.MemoKey = GetSurrogateKey("tciMemo"); var parameters = new SqlParameter[] { new SqlParameter("@MemoKey", remark.MemoKey), new SqlParameter("@MemoType", remark.TypeId), new SqlParameter("@EntityType", remark.EntityType), new SqlParameter("@OwnerKey", remark.OwnerKey), new SqlParameter("@MemoText", remark.MemoText), new SqlParameter("@UserID", remark.UserId) }; var command = new SqlCommand("spCPCmmAddRemark", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(parameters); command.ExecuteNonQuery(); } }
public Remark Clone() { var remarkToReturn = new Remark(); remarkToReturn.Initialize(RemarkType, MemoKey, DateStamp, MemoText, IsDirty); return(remarkToReturn); }
//FORM LOAD private void EditForm_Load(object sender, EventArgs e) { Text = context.OwnerName + " [" + context.OwnerId + "] " + context.EntityName; //+ " Remarks [" + context.Server + "]" dgvRemarks.Columns["MemoText"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgvRemarks.Columns["MemoText"].DefaultCellStyle.WrapMode = DataGridViewTriState.True; dgvRemarks.DataSource = context.Remarks; selectedRemark = context.Remarks.FirstOrDefault(); UpdateControls(); }
//NEW private void btnNew_Click(object sender, EventArgs e) { if (txtMemoText.Text.Length > 0) { btnSave.PerformClick(); } var chooseTypeForm = new ChooseTypeForm(); var remarkTypeSelected = chooseTypeForm.ChooseType(context); if (remarkTypeSelected == null) { return; } selectedRemark = new Remark(); selectedRemark.RemarkType = remarkTypeSelected; loading = true; txtMemoText.Text = ""; txtMemoText.Enabled = true; txtMemoText.Focus(); foreach (DictionaryEntry type in context.RemarkTypes) { var remarkType = (RemarkType)type.Value; if (remarkType.CanCreate == 1) { cboRemarkType.Items.Add(remarkType.Caption); } } cboRemarkType.Text = remarkTypeSelected.Caption; cboRemarkType.Enabled = true; loading = false; btnDelete.Enabled = false; btnSave.Enabled = true; grpRemarkEdit.Text = "Edit Remark"; }
public bool CanCreate(int indexOrKey) { Remark remark = Remarks.FirstOrDefault(c => c.MemoKey == indexOrKey); if ((remark == null) && indexOrKey > (Remarks.Count - 1)) { remark = Remarks[indexOrKey]; } if (remark != null) { var remarkType = (RemarkType)RemarkTypes[remark.TypeId]; if (remarkType != null) { return(remarkType.CanCreate == 1); } } return(false); }
//SELECTION CHANGED private void dgvRemarks_SelectionChanged(object sender, EventArgs e) { if (loading) { return; } if (dgvRemarks.SelectedRows.Count == 0) { return; } if (txtMemoText.Text.Length > 0) { btnSave.PerformClick(); } selectedRemark = (Remark)dgvRemarks.SelectedRows[0].DataBoundItem; loading = true; UpdateControls(); loading = false; }
public void AddRemark(object remarkIndex, string remarkText, string userId) { RemarkType remarkType = null; if (remarkIndex is int) { var index = Convert.ToInt32(remarkIndex); remarkType = (RemarkType)RemarkTypes[index]; } if (remarkIndex is string) { var index = remarkIndex.ToString(); remarkType = (RemarkType)RemarkTypes[index]; } if (remarkType == null) { throw new Exception("Illegal remark type for this context"); } if (Remarks == null) { Remarks = new List <Remark>(); } var remark = new Remark(); remark.RemarkType = remarkType; remark.MemoText = remarkText; remark.UserId = userId; remark.DateStamp = DateTime.Now; remark.IsDirty = true; Remarks.Add(remark); }