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