protected void GridView_Notes_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
String commId = ((Label)GridView_Notes.Rows[e.RowIndex].Cells[0].FindControl("Label_Hidden_Comm")).Text;
Dictionary <String, String> whereCls = new Dictionary <string, string>();
Dictionary <String, String> targetVals = new Dictionary <string, string>();
whereCls.Add(BackEndObjects.Communications.COMMUNICATIONS_COL_COMM_ID, commId);
BackEndObjects.Communications.updateCommunicationDB(targetVals, whereCls, DBConn.Connections.OPERATION_DELETE);
DataTable dt = ((Dictionary <String, DataTable>)Session[SessionFactory.ALL_MSGS_DATAGRID])[Request.QueryString.GetValues("contextId")[0]];
int index = GridView_Notes.Rows[e.RowIndex].DataItemIndex;
dt.Rows[index].Delete();
GridView_Notes.DataSource = dt;
GridView_Notes.DataBind();
}
protected void Button_Submit_Note_Click(object sender, EventArgs e)
{
String[] contextId = Request.QueryString.GetValues("contextId");
BackEndObjects.Communications commObj = new BackEndObjects.Communications();
commObj.setCommId(new Id().getNewId(Id.ID_TYPE_COMM_STRING));
commObj.setContextId(contextId[0]);
commObj.setDateCreated(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
commObj.setFromEntityId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
commObj.setFromUserId(User.Identity.Name);
commObj.setText(TextBox_Note.Text);
commObj.setToEntityId("");
commObj.setToUserId("");
commObj.setContextType(Communications.COMMUNICATIONS_CONTEXT_TYPE_NOTE);
if (FileUpload_Attachment != null && FileUpload_Attachment.HasFile)
{
if (FileUpload_Attachment.PostedFile.ContentLength == 0)
{
Label_Insert_Stat.Text = "Empty file will not be uploaded";
Label_Insert_Stat.Visible = true;
Label_Insert_Stat.ForeColor = System.Drawing.Color.Red;
}
else
{
Label_Insert_Stat.Visible = false;
commObj.setFileStream(FileUpload_Attachment);
commObj.setDocPathInFileStore(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
}
}
try
{
BackEndObjects.Communications.insertCommunicationDB(commObj);
Label_Insert_Stat.Visible = true;
Label_Insert_Stat.Text = "Note Saved Successfully";
Label_Insert_Stat.ForeColor = System.Drawing.Color.Green;
Dictionary <String, DataTable> notesData = (Dictionary <String, DataTable>)Session[SessionFactory.ALL_NOTES_DATAGRID];
DataTable dt = null;
if (notesData != null)
{
if (notesData.ContainsKey(contextId[0]))
{
dt = notesData[contextId[0]];
}
else
{
dt = new DataTable();
dt.Columns.Add("HiddenComm");
dt.Columns.Add("RespDateTime");
dt.Columns.Add("FromUsr");
dt.Columns.Add("docName");
dt.Columns.Add("Comments");
}
}
else
{
dt = new DataTable();
dt.Columns.Add("HiddenComm");
dt.Columns.Add("RespDateTime");
dt.Columns.Add("FromUsr");
dt.Columns.Add("docName");
dt.Columns.Add("Comments");
}
int counter = 0;
if (dt == null)
{
dt = new DataTable();
}
else
{
counter = dt.Rows.Count;
}
dt.Rows.Add();
String docName = "";
if (commObj.getDocPath() != null && !commObj.getDocPath().Equals(""))
{
String[] docPathList = commObj.getDocPath().
Split(new String[] { "\\" }, StringSplitOptions.RemoveEmptyEntries);
if (docPathList.Length > 0)
{
docName = docPathList[docPathList.Length - 1];
}
}
dt.Rows[counter]["HiddenComm"] = commObj.getCommId();
dt.Rows[counter]["RespDateTime"] = commObj.getDateCreated();
dt.Rows[counter]["FromUsr"] = commObj.getFromUserId();
dt.Rows[counter]["docName"] = (docName == null || docName.Equals("") ? "N/A" :
docName.Remove(0, (docName.IndexOf("_") + 1 + docName.Substring(docName.IndexOf("_") + 1).IndexOf("_") + 1)));
dt.Rows[counter]["Comments"] = commObj.getText();
dt.DefaultView.Sort = "RespDateTime" + " " + "DESC";
DataTable sorteddt = dt.DefaultView.ToTable();
GridView_Notes.DataSource = sorteddt;
GridView_Notes.DataBind();
GridView_Notes.Visible = true;
GridView_Notes.Columns[0].Visible = false;
if (notesData == null)
{
notesData = new Dictionary <string, DataTable>();
}
if (notesData.ContainsKey(contextId[0]))
{
notesData[contextId[0]] = sorteddt;
}
else
{
notesData.Add(contextId[0], sorteddt);
}
Session[SessionFactory.ALL_NOTES_DATAGRID] = notesData;
}
catch (Exception ex)
{
Label_Insert_Stat.Visible = true;
Label_Insert_Stat.Text = "Note Could not be saved";
Label_Insert_Stat.ForeColor = System.Drawing.Color.Red;
}
}
protected void fillGrid()
{
String[] contextId = Request.QueryString.GetValues("contextId");
Dictionary <String, BackEndObjects.Communications> allComm = Communications.
getAllCommunicationsforContextIdAndContextTypeAndSourceIdDB(
contextId[0],
Communications.COMMUNICATIONS_CONTEXT_TYPE_NOTE,
Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
DataTable dt = new DataTable();
dt.Columns.Add("HiddenComm");
dt.Columns.Add("RespDateTime");
dt.Columns.Add("FromUsr");
dt.Columns.Add("docName");
dt.Columns.Add("Comments");
int counter = 0;
foreach (KeyValuePair <String, BackEndObjects.Communications> kvp in allComm)
{
BackEndObjects.Communications commObj = kvp.Value;
dt.Rows.Add();
String docName = "";
if (commObj.getDocPath() != null && !commObj.getDocPath().Equals(""))
{
String[] docPathList = commObj.getDocPath().
Split(new String[] { "\\" }, StringSplitOptions.RemoveEmptyEntries);
if (docPathList.Length > 0)
{
docName = docPathList[docPathList.Length - 1];
}
}
dt.Rows[counter]["HiddenComm"] = commObj.getCommId();
dt.Rows[counter]["RespDateTime"] = commObj.getDateCreated();
dt.Rows[counter]["FromUsr"] = commObj.getFromUserId();
dt.Rows[counter]["docName"] = (docName == null || docName.Equals("") ? "N/A" :
docName.Remove(0, (docName.IndexOf("_") + 1 + docName.Substring(docName.IndexOf("_") + 1).IndexOf("_") + 1)));
dt.Rows[counter]["Comments"] = commObj.getText();
counter++;
}
if (dt.Rows.Count > 0)
{
dt.DefaultView.Sort = "RespDateTime" + " " + "DESC";
DataTable sortedTable = dt.DefaultView.ToTable();
GridView_Notes.DataSource = sortedTable;
GridView_Notes.DataBind();
GridView_Notes.Visible = true;
GridView_Notes.Columns[0].Visible = false;
Dictionary <String, DataTable> notesData = new Dictionary <string, DataTable>();
notesData.Add(contextId[0], sortedTable);
Session[SessionFactory.ALL_NOTES_DATAGRID] = notesData;
}
}