protected void GrdFreeText_Sorting(object sender, GridViewSortEventArgs e) { try { if (!object.Equals(ViewState["GridFreeTextData"], null)) { DataTable dtrslt = (DataTable)ViewState["GridFreeTextData"]; if (dtrslt.Rows.Count > 0) { if (Convert.ToString(ViewState["sortdr"]) == "Asc") { dtrslt.DefaultView.Sort = e.SortExpression + " Desc"; ViewState["sortdr"] = "Desc"; } else { dtrslt.DefaultView.Sort = e.SortExpression + " Asc"; ViewState["sortdr"] = "Asc"; } GrdFreeText.DataSource = dtrslt; GrdFreeText.DataBind(); } } } catch (Exception ex) { } }
void FillGrid(int Ptn_pk, int Visit_pk) { //Session["PatientId"]; IFreeText FreeTextManager; try { FreeTextManager = (IFreeText)ObjectFactory.CreateInstance("BusinessProcess.Clinical.BFreeText, BusinessProcess.Clinical"); DataSet theDs = FreeTextManager.GetFreeText(Ptn_pk, Visit_pk); if (theDs != null && theDs.Tables[0].Rows.Count > 0) { btnsaveFreeText.Visible = true; ViewState["GridFreeTextData"] = theDs.Tables[0]; GrdFreeText.DataSource = theDs.Tables[0]; GrdFreeText.DataBind(); ViewState["sortdr"] = "Asc"; } else { btnsaveFreeText.Visible = false; } } catch (Exception ex) { } }
private void AddFreeText(int visitID) { DataTable dt = new DataTable(); DataRow dr; try { dt.Columns.Add("ptn_pk"); dt.Columns.Add("Visit_pk"); dt.Columns.Add("Form_filling_date"); dt.Columns.Add("DescriptiveHeading"); dt.Columns.Add("Description"); dt.Columns.Add("Freetext_id"); dr = dt.NewRow(); if (ViewState["GridFreeTextData"] == null) { dr["ptn_pk"] = Convert.ToInt32(Session["PatientId"] == null ? "0" : Session["PatientId"]); dr["Visit_pk"] = Convert.ToString(visitID); dr["Form_filling_date"] = "" + txtDate.Value.Trim() + ""; dr["DescriptiveHeading"] = txtDescriptiveHeading.Text.Trim(); dr["Description"] = txtDescription.Text.Trim(); dr["Freetext_id"] = CreateUniqueNo(); dt.Rows.Add(dr); ViewState["GridFreeTextData"] = dt; } else { dr["ptn_pk"] = Convert.ToInt32(Session["PatientId"] == null ? "0" : Session["PatientId"]); dr["Visit_pk"] = Convert.ToString(visitID); dr["Form_filling_date"] = "" + txtDate.Value.Trim() + ""; dr["DescriptiveHeading"] = txtDescriptiveHeading.Text.Trim(); dr["Description"] = txtDescription.Text.Trim(); dr["Freetext_id"] = CreateUniqueNo(); DataTable dt1 = (DataTable)ViewState["GridFreeTextData"]; dt1.LoadDataRow(new object[] { dr["ptn_pk"], dr["Visit_pk"], dr["Form_filling_date"], dr["DescriptiveHeading"], dr["Description"], dr["Freetext_id"] }, true); ViewState["GridFreeTextData"] = dt1; } //GrdFreeText.Columns.Clear(); GrdFreeText.DataSource = ((DataTable)ViewState["GridFreeTextData"]); GrdFreeText.DataBind(); if (GrdFreeText.Rows.Count > 0) { btnsaveFreeText.Visible = true; } else { btnsaveFreeText.Visible = false; } ClearData(); ViewState["sortdr"] = "Asc"; } catch (Exception ex) { } }
protected void GrdFreeText_RowDeleting(object sender, GridViewDeleteEventArgs e) { System.Data.DataTable theDT = new System.Data.DataTable(); theDT = ((DataTable)ViewState["GridFreeTextData"]); int r = Convert.ToInt32(e.RowIndex.ToString()); int Id = -1; try { if (theDT.Rows.Count > 0) { if (theDT.Rows[r].HasErrors == false) { if ((theDT.Rows[r]["Freetext_id"] != null) && (theDT.Rows[r]["Freetext_id"] != DBNull.Value)) { if (theDT.Rows[r]["Freetext_id"].ToString() != "") { Id = Convert.ToInt32(theDT.Rows[r]["Freetext_id"]); theDT.Rows[r].Delete(); theDT.AcceptChanges(); ViewState["GridFreeTextData"] = theDT; GrdFreeText.DataSource = (DataTable)ViewState["GridFreeTextData"]; GrdFreeText.DataBind(); //IQCareMsgBox.ShowfromPage("DeleteSuccess", this); } } } } else { //GrdFreeText.Visible = false; } } catch (Exception ex) { string str = ex.Message; } }