private void UpdateLineNumber(int ProcNotes_Line_ID, int LineNumber, int LastUpdatedBy)
{
objProcedureNotes_Bal = new clsProcedureNotes_BAL();
int _ID = 0;
_ID = objProcedureNotes_Bal.UpdateProcedureNotesLineNumber(ProcNotes_Line_ID, LineNumber, LastUpdatedBy);
//string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
//using (SqlConnection con = new SqlConnection(constr))
//{
// using (SqlCommand cmd = new SqlCommand("UPDATE HolidayLocations SET Preference = @Preference WHERE Id = @Id"))
// {
// using (SqlDataAdapter sda = new SqlDataAdapter())
// {
// cmd.CommandType = CommandType.Text;
// cmd.Parameters.AddWithValue("@Id", locationId);
// cmd.Parameters.AddWithValue("@Preference", preference);
// cmd.Connection = con;
// con.Open();
// cmd.ExecuteNonQuery();
// con.Close();
// }
// }
//}
}
protected void lnkbtnUpdateNotes_Click(object sender, EventArgs e)
{
objProcedureNotes_Bal = new clsProcedureNotes_BAL();
objProcedureNotesEntity = new ProcedureNotes_Entity();
objProcedureNotesLinesEntity = new ProcNotes_Lines_Entity();
if (lblProcNotes_Line_ID.Text.ToString() != "")
{
objProcedureNotesLinesEntity.ProcNotes_Line_ID = Convert.ToInt32(lblProcNotes_Line_ID.Text.ToString());
objProcedureNotesLinesEntity.ProcNotes_ID = Convert.ToInt32(lblProcNotes_ID.Text.ToString());
objProcedureNotesLinesEntity.LineNumber = Convert.ToInt32(lblLineNumber.Text);
objProcedureNotesLinesEntity.Notes_Type = rbtnlstNotesType.SelectedItem.Text.ToString();
objProcedureNotesLinesEntity.Notes = CKEditorControl1.Text.ToString();
objProcedureNotesLinesEntity.Notes_Binary = new byte[0];
if (rbtnlstActiveInActive.SelectedItem.Text == "Active")
{
objProcedureNotesLinesEntity.IsActive = true;
}
else if (rbtnlstActiveInActive.SelectedItem.Text == "InActive")
{
objProcedureNotesLinesEntity.IsActive = false;
}
objProcedureNotesLinesEntity.CreatedBy = Convert.ToInt32(Session["UserID"]);;
objProcedureNotesLinesEntity.LastUpdatedBy = Convert.ToInt32(Session["UserID"]);;
ProcNotes_Line_ID = objProcedureNotes_Bal.InsertUpdateProcedureNotesLines(objProcedureNotesLinesEntity);
if (objProcedureNotesLinesEntity.LineNumber == 1 && objProcedureNotesLinesEntity.Notes_Type.ToString() == "Text")
{
objProcedureNotesEntity.ProcNotes_ID = objProcedureNotesLinesEntity.ProcNotes_ID;
objProcedureNotesEntity.Notes = objProcedureNotesLinesEntity.Notes;
objProcedureNotesEntity.LastUpdatedBy = Convert.ToInt32(Session["UserID"]);;
objProcedureNotesEntity.SerialNumber = "";
ProcNotes_ID = objProcedureNotes_Bal.InsertUpdateProcedureNotes(objProcedureNotesEntity);
}
if (ProcNotes_Line_ID > 0)
{
CKEditorControl1.Text = "";
rbtnlstNotesType.Text = "Text";
rbtnlstNotesType.Items.FindByText("Text").Selected = true;
rbtnlstActiveInActive.Text = "Active";
rbtnlstActiveInActive.Items.FindByText("Active").Selected = true;
GetProcNoteLine(Convert.ToInt32(lblProcNotes_ID.Text.ToString()));
GetProcNotesByProcID();
}
}
}
protected void tvProcNotes_SelectedNodeChanged(object sender, EventArgs e)
{
objProcedureNotes_Bal = new clsProcedureNotes_BAL();
_ProcNotes_ID = Convert.ToInt32(tvProcNotes.SelectedNode.Value.ToString());
hfProcNotes_ID.Value = _ProcNotes_ID.ToString();
DataTable dt = (DataTable)Session["dt_ProcNotes"];
DataRow dr = dt.AsEnumerable().SingleOrDefault(r => r.Field <int>("ProcNotes_ID") == _ProcNotes_ID);
int _ParentID = Convert.ToInt32(dr["ParentID"].ToString());
hfParentID.Value = _ParentID.ToString();
int _SequenceNumber = Convert.ToInt32(dr["SequenceNumber"].ToString());
hfSequenceNumber.Value = _SequenceNumber.ToString();
string _SerialNumber = dr["SerialNumber"].ToString();
hfSerialNumber.Value = _SerialNumber.ToString();
string _Notes = dr["Notes"].ToString();
//CKEditorControl1.Text = _Notes.ToString();
GetProcNoteLine(Convert.ToInt32(hfProcNotes_ID.Value.ToString()));
if (_ParentID > 0)
{
rbtnlstNotesType.Visible = true;
rbtnlstActiveInActive.Visible = true;
CKEditorControl1.Visible = true;
lnkbtnAddLine.Visible = true;
CKEditorControl1.Text = "";
lnkbtnUpdateNotes.Visible = false;
lnkbtnCancel.Visible = false;
}
else
{
rbtnlstNotesType.Visible = false;
rbtnlstActiveInActive.Visible = false;
CKEditorControl1.Visible = false;
lnkbtnAddLine.Visible = false;
}
}
public void GetProcNotesByProcID()
{
try
{
dt_ProcNotes = new DataTable();
objProcedureNotes_Bal = new clsProcedureNotes_BAL();
dt_ProcNotes = objProcedureNotes_Bal.GetProcNotesByProcID(Convert.ToInt32(ddlProcedureList.SelectedItem.Value.ToString()));
if (dt_ProcNotes != null)
{
if (dt_ProcNotes.Rows.Count > 0)
{
tvProcNotes.Visible = true;
lnkbtnDeleteNode.Visible = true;
Session["dt_ProcNotes"] = dt_ProcNotes;
PopulateTree(tvProcNotes, dt_ProcNotes);
tvProcNotes.ExpandAll();
}
else
{
tvProcNotes.Visible = false;
rbtnlstNotesType.Visible = false;
rbtnlstActiveInActive.Visible = false;
CKEditorControl1.Text = "";
CKEditorControl1.Visible = false;
lnkbtnAddLine.Visible = false;
lnkbtnDeleteNode.Visible = false;
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.ToString());
}
}
public void BindAllNotesForReport()
{
try
{
dt_ProcReportData = new DataTable();
objProcedureNotes_Bal = new clsProcedureNotes_BAL();
dt_ProcReportData = objProcedureNotes_Bal.GetProcReportData(Convert.ToInt32(ddlProcedureList.SelectedItem.Value.ToString()));
if (dt_ProcReportData != null)
{
if (dt_ProcReportData.Rows.Count > 0)
{
var strPath = "ACHEQA_Parametric_Automation_Admin.Reports.ProcReportData.rdlc";
ReportViewer1.LocalReport.ReportEmbeddedResource = strPath;
ReportDataSource _rsource = new ReportDataSource("dsProcReportData", dt_ProcReportData);
ReportViewer1.LocalReport.DataSources.Add(_rsource);
ReportViewer1.LocalReport.Refresh();
ReportViewer1.Visible = true;
Image1.Visible = false;
}
else
{
ReportViewer1.Visible = false;
Image1.Visible = true;
}
}
else
{
ReportViewer1.Visible = false;
Image1.Visible = true;
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.Write(ex.ToString());
}
}
protected void lnkbtnAddLine_Click(object sender, EventArgs e)
{
objProcedureNotes_Bal = new clsProcedureNotes_BAL();
objProcedureNotesLinesEntity = new ProcNotes_Lines_Entity();
if (Convert.ToInt32(hfProcNotes_ID.Value.ToString()) > 0)
{
if (rbtnlstNotesType.SelectedItem.Text.ToString() == "Text")
{
if (CKEditorControl1.Text == "")
{
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage2", "Showalert_Notes();", true);
return;
}
}
int _LineNumber = 0;
ProcNotes_Line_ID = 0;
objProcedureNotesLinesEntity = new ProcNotes_Lines_Entity();
objProcedureNotesLinesEntity.ProcNotes_Line_ID = ProcNotes_Line_ID;
if (Convert.ToInt32(hfParentID.Value.ToString()) == 0)
{
objProcedureNotesLinesEntity.ProcNotes_ID = ProcNotes_ID;
}
else
{
objProcedureNotesLinesEntity.ProcNotes_ID = Convert.ToInt32(hfProcNotes_ID.Value.ToString());
}
_LineNumber = objProcedureNotes_Bal.GetMaxLineNumber(Convert.ToInt32(hfProcNotes_ID.Value.ToString()));
objProcedureNotesLinesEntity.LineNumber = _LineNumber + 1;
objProcedureNotesLinesEntity.Notes_Type = rbtnlstNotesType.SelectedItem.Text.ToString();
string _htmltext = "";
_htmltext = CKEditorControl1.Text.ToString();
objProcedureNotesLinesEntity.Notes = _htmltext;
//objProcedureNotesLinesEntity.Notes = Addnewline(_htmltext);
//objProcedureNotesLinesEntity.Notes = Addnewline(_htmltext,125);
objProcedureNotesLinesEntity.Notes_Binary = new byte[0];
if (rbtnlstActiveInActive.SelectedItem.Text == "Active")
{
objProcedureNotesLinesEntity.IsActive = true;
}
else if (rbtnlstActiveInActive.SelectedItem.Text == "InActive")
{
objProcedureNotesLinesEntity.IsActive = false;
}
objProcedureNotesLinesEntity.CreatedBy = Convert.ToInt32(Session["UserID"]);;
objProcedureNotesLinesEntity.LastUpdatedBy = Convert.ToInt32(Session["UserID"]);;
ProcNotes_Line_ID = objProcedureNotes_Bal.InsertUpdateProcedureNotesLines(objProcedureNotesLinesEntity);
hfProcNotes_Line_ID.Value = ProcNotes_Line_ID.ToString();
if (ProcNotes_Line_ID > 0)
{
CKEditorControl1.Text = "";
rbtnlstNotesType.Text = "Text";
rbtnlstNotesType.Items.FindByText("Text").Selected = true;
rbtnlstActiveInActive.Text = "Active";
rbtnlstActiveInActive.Items.FindByText("Active").Selected = true;
GetProcNoteLine(Convert.ToInt32(hfProcNotes_ID.Value.ToString()));
}
}
}
protected void lnkbtnAddNode_Click(object sender, EventArgs e)
{
objProcedureNotes_Bal = new clsProcedureNotes_BAL();
int _ProcID = 0;
int _CountOfProcID = 0;
int _SequenceNumber = 0;
int _SNO = 0;
int _ChildNotesCount = 0;
int _SeqNum = 0;
int _ParentID = 0;
if (ddlProcedureList.SelectedItem.Value == "-1")
{
ScriptManager.RegisterStartupScript(this, GetType(), "displayalertmessage1", "Showalert_ProcedureList();", true);
return;
}
else
{
objProcedureNotesEntity = new ProcedureNotes_Entity();
_ProcID = Convert.ToInt32(ddlProcedureList.SelectedItem.Value.ToString());
_CountOfProcID = objProcedureNotes_Bal.GetCountOfProc_ID(_ProcID);
if (_CountOfProcID > 0)
{
if (Convert.ToInt32(hfParentID.Value.ToString()) == 0)
{
_ParentID = Convert.ToInt32(hfParentID.Value.ToString());
objProcedureNotesEntity.SequenceNumber = 1;
objProcedureNotesEntity.SeqNum = 1;
_SNO = objProcedureNotes_Bal.GetCountOfChildNodes(Convert.ToInt32(hfProcNotes_ID.Value.ToString()));
objProcedureNotesEntity.SNO = _SNO + 1;
objProcedureNotesEntity.SerialNumber = objProcedureNotesEntity.SNO.ToString();
objProcedureNotesEntity.Notes = (objProcedureNotesEntity.SNO) + " - Blank";
}
else
{
_ParentID = Convert.ToInt32(hfParentID.Value.ToString());
_SequenceNumber = objProcedureNotes_Bal.GetMaxSequenceNumber(Convert.ToInt32(hfProcNotes_ID.Value.ToString()));
_SeqNum = objProcedureNotes_Bal.GetMaxSeqNum(Convert.ToInt32(hfProcNotes_ID.Value.ToString()));
_ChildNotesCount = objProcedureNotes_Bal.GetCountOfChildNodes(Convert.ToInt32(hfProcNotes_ID.Value.ToString()));
if (_ChildNotesCount > 0)
{
objProcedureNotesEntity.SeqNum = _SeqNum + 1;
objProcedureNotesEntity.SerialNumber = hfSerialNumber.Value.ToString() + "." + objProcedureNotesEntity.SeqNum.ToString();
}
else
{
objProcedureNotesEntity.SeqNum = 1;
objProcedureNotesEntity.SerialNumber = hfSerialNumber.Value.ToString() + "." + objProcedureNotesEntity.SeqNum.ToString();
}
objProcedureNotesEntity.SNO = 0;
objProcedureNotesEntity.SequenceNumber = _SequenceNumber + 1;
objProcedureNotesEntity.Notes = objProcedureNotesEntity.SerialNumber.ToString() + " - Blank";
}
ProcNotes_ID = 0;
objProcedureNotesEntity.ProcNotes_ID = ProcNotes_ID;
objProcedureNotesEntity.Proc_ID = _ProcID;
objProcedureNotesEntity.ParentID = Convert.ToInt32(hfProcNotes_ID.Value.ToString());
lblParentID.Text = objProcedureNotesEntity.ParentID.ToString();
objProcedureNotesEntity.CreatedBy = Convert.ToInt32(Session["UserID"]);
objProcedureNotesEntity.LastUpdatedBy = Convert.ToInt32(Session["UserID"]);;
}
else
{
ProcNotes_ID = 0;
objProcedureNotesEntity = new ProcedureNotes_Entity();
objProcedureNotesEntity.ProcNotes_ID = ProcNotes_ID;
objProcedureNotesEntity.Proc_ID = _ProcID;
objProcedureNotesEntity.ParentID = 0;
objProcedureNotesEntity.SerialNumber = "0";
objProcedureNotesEntity.Notes = ddlProcedureList.SelectedItem.Text.ToString();
objProcedureNotesEntity.CreatedBy = Convert.ToInt32(Session["UserID"]);;
objProcedureNotesEntity.LastUpdatedBy = Convert.ToInt32(Session["UserID"]);;
objProcedureNotesEntity.SequenceNumber = 0;
objProcedureNotesEntity.SNO = 0;
objProcedureNotesEntity.SeqNum = 0;
_ParentID = 0;
}
ProcNotes_ID = objProcedureNotes_Bal.InsertUpdateProcedureNotes(objProcedureNotesEntity);
if (ProcNotes_ID > 0)
{
if (objProcedureNotesEntity.ParentID > 0)
{
int _LineNumber = 0;
ProcNotes_Line_ID = 0;
objProcedureNotesLinesEntity = new ProcNotes_Lines_Entity();
objProcedureNotesLinesEntity.ProcNotes_Line_ID = ProcNotes_Line_ID;
objProcedureNotesLinesEntity.ProcNotes_ID = ProcNotes_ID;
_LineNumber = objProcedureNotes_Bal.GetMaxLineNumber(ProcNotes_ID);
objProcedureNotesLinesEntity.LineNumber = _LineNumber + 1;
objProcedureNotesLinesEntity.Notes_Type = "Text";
objProcedureNotesLinesEntity.Notes = objProcedureNotesEntity.Notes.ToString();
objProcedureNotesLinesEntity.Notes_Binary = new byte[0];
objProcedureNotesLinesEntity.IsActive = true;
objProcedureNotesEntity.CreatedBy = Convert.ToInt32(Session["UserID"]);;
objProcedureNotesEntity.LastUpdatedBy = Convert.ToInt32(Session["UserID"]);
ProcNotes_Line_ID = objProcedureNotes_Bal.InsertUpdateProcedureNotesLines(objProcedureNotesLinesEntity);
hfProcNotes_Line_ID.Value = ProcNotes_Line_ID.ToString();
}
else
{
}
}
if (ProcNotes_ID > 0)
{
GetProcNotesByProcID();
}
}
}
