public string SaveUI_Ajax()
{
string ieMode = "New";
string ieID = Session["PatientIE_ID"].ToString();
bool bpChecked = true;
// string result= SaveUI(Session["PatientIE_ID"].ToString(), ieMode, true);
long _ieID = Convert.ToInt64(ieID);
string _ieMode = "";
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblbpNeck WHERE PatientIE_ID = " + ieID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["PatientIE_ID"] = _ieID;
//TblRow["FreeForm"] = txtFreeForm.Text.ToString();
//TblRow["FreeFormCC"] = txtFreeFormCC.Text.ToString();
TblRow["FreeFormA"] = txtFreeFormA.Text.ToString().Trim().Replace(" ", string.Empty);
TblRow["FreeFormP"] = txtFreeFormP.Text.ToString();
TblRow["Xrays"] = false; //TBD
TblRow["TPEpidular"] = false; //TBD
TblRow["NoOfTPInjections"] = ""; // txtPainScale;
TblRow["ScheduleEpidural"] = false; //txtPainScale;
TblRow["NewMBB"] = false; // txtPainScale;
TblRow["SPTPMBB"] = false; //txtPainScale;
TblRow["ISFirst"] = true;
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (_ieMode == "New")
{
return("Neck has been added...");
}
else if (_ieMode == "Update")
{
return("Neck has been updated...");
}
else if (_ieMode == "Delete")
{
return("Neck has been deleted...");
}
else
{
return("");
}
}
public void SaveStdUI(string ieID, string iStdID, string heading, string pdesc)
{
string[] _Type = iStdID.Split('_');
int _StdID = Convert.ToInt32(_Type[0]);
string Part = Convert.ToString(_Type[1]);
string _ieMode = "";
long _ieID = Convert.ToInt64(ieID);
//long _StdID = Convert.ToInt64(iStdID);
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblProceduresDetail WHERE PatientIE_ID = " + ieID + " AND ProcedureDetail_ID = " + _StdID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
//if (sqlTbl.Rows.Count == 0 && StdChecked == true)
// _ieMode = "New";
//else if (sqlTbl.Rows.Count == 0 && StdChecked == false)
// _ieMode = "None";
//else if (sqlTbl.Rows.Count > 0 && StdChecked == false)
// _ieMode = "Delete";
//else
_ieMode = "Update";
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["ProcedureDetail_ID"] = _StdID;
TblRow["PatientIE_ID"] = _ieID;
if (Part.Equals("R"))
{
TblRow["Heading"] = heading.ToString().Trim();
TblRow["PDesc"] = pdesc.ToString().Trim();
}
else if (Part.Equals("S"))
{
TblRow["S_Heading"] = heading.ToString().Trim();
TblRow["S_PDesc"] = pdesc.ToString().Trim();
}
else if (Part.Equals("E"))
{
TblRow["E_Heading"] = heading.ToString().Trim();
TblRow["E_PDesc"] = pdesc.ToString().Trim();
}
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
}
public void SaveDiagUI(string ieID, string iDiagID, bool DiagChecked, string bp, string dcd, string dc)
{
string _ieMode = "";
long _ieID = Convert.ToInt64(ieID);
long _DiagID = Convert.ToInt64(iDiagID);
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * FROM tblDiagCodesDetail WHERE PatientIE_ID = " + ieID + " AND Diag_Master_ID = " + _DiagID + " AND PatientFu_ID=" + Session["patientFUId"].ToString() + " and BodyPart like '%" + _CurBP + "%' ";
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && DiagChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && DiagChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && DiagChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["Diag_Master_ID"] = _DiagID;
TblRow["PatientIE_ID"] = _ieID;
TblRow["PatientFU_ID"] = Session["patientFUId"].ToString();
TblRow["BodyPart"] = bp.ToString().Trim();
TblRow["DiagCode"] = dc.ToString().Trim();
TblRow["Description"] = dcd.ToString().Trim();
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
}
public string SaveUI(string ieID, string ieMode, bool bpIsChecked)
{
long _ieID = Convert.ToInt64(ieID);
string _ieMode = "";
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblbpElbow WHERE PatientIE_ID = " + ieID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpIsChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpIsChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpIsChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["PatientIE_ID"] = _ieID;
TblRow["ExtensionROM1"] = txtExtension1.Text.Trim();
TblRow["ExtensionROM2"] = txtExtension2.Text.Trim();
TblRow["FlexionROM1"] = txtFlex1.Text.Trim();
TblRow["FlexionROM2"] = txtFlex2.Text.Trim();
TblRow["FlexionROMNormal"] = txtFlex3.Text.Trim();
TblRow["ExtensionROMNormal"] = txtExtension3.Text.Trim();
TblRow["SupinationROMNormal"] = txtSupination3.Text.Trim();
TblRow["PronationROMNormal"] = txtPronation3.Text.Trim();
TblRow["SupinationROM1"] = txtSupination1.Text.Trim();
TblRow["SupinationROM2"] = txtSupination2.Text.Trim();
TblRow["PronationROM1"] = txtPronation1.Text.Trim();
TblRow["PronationROM2"] = txtPronation2.Text.Trim();
TblRow["FreeFormA"] = txtFreeFormA.Text.ToString();
TblRow["FreeFormP"] = txtFreeFormP.Text.ToString();
TblRow["CCvalue"] = hdCCvalue.Value;
TblRow["PEvalue"] = hdPEvalue.Value;
string strname = "", strleft = "", strright = "", strnormal = "";
for (int i = 0; i < repROM.Items.Count; i++)
{
Label lblname = repROM.Items[i].FindControl("lblname") as Label;
TextBox txtleft = repROM.Items[i].FindControl("txtleft") as TextBox;
TextBox txtright = repROM.Items[i].FindControl("txtright") as TextBox;
TextBox txtnormal = repROM.Items[i].FindControl("txtnormal") as TextBox;
strname = strname + "," + lblname.Text;
strleft = strleft + "," + txtleft.Text;
strright = strright + "," + txtright.Text;
strnormal = strnormal + "," + txtnormal.Text;
}
TblRow["LeftROM"] = strleft.Substring(1);
TblRow["RightROM"] = strright.Substring(1);
TblRow["NormalROM"] = strnormal.Substring(1);
TblRow["NameROM"] = strname.Substring(1);
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (pageHDN.Value != null && pageHDN.Value != "")
{
Response.Redirect(pageHDN.Value.ToString());
}
if (_ieMode == "New")
{
return("Elbow has been added...");
}
else if (_ieMode == "Update")
{
return("Elbow has been updated...");
}
else if (_ieMode == "Delete")
{
return("Elbow has been deleted...");
}
else
{
return("");
}
}
public string SaveUI(string ieID, string fuID, string fuMode, bool bpIsChecked)
{
long _fuID = Convert.ToInt64(fuID);
string _fuMode = "";
string sProvider = System.Configuration.ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblFUbpNeck WHERE PatientFU_ID = " + _fuID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpIsChecked == true)
{
_fuMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpIsChecked == false)
{
_fuMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpIsChecked == false)
{
_fuMode = "Delete";
}
else
{
_fuMode = "Update";
}
if (_fuMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_fuMode == "Update" || _fuMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_fuMode == "Update" || _fuMode == "New")
{
TblRow["PatientFU_ID"] = _fuID;
//TblRow["FreeForm"] = txtFreeForm.Text.ToString();
//TblRow["FreeFormCC"] = txtFreeFormCC.Text.ToString();
TblRow["FreeFormA"] = txtFreeFormA.Text.ToString().Trim().Replace(" ", string.Empty);
TblRow["FreeFormP"] = txtFreeFormP.Text.ToString();
TblRow["Xrays"] = false; //TBD
TblRow["TPEpidular"] = false; //TBD
TblRow["NoOfTPInjections"] = ""; // txtPainScale;
TblRow["ScheduleEpidural"] = false; //txtPainScale;
TblRow["NewMBB"] = false; // txtPainScale;
TblRow["SPTPMBB"] = false; //txtPainScale;
TblRow["CCvalue"] = hdCCvalue.Value;
TblRow["PEvalue"] = hdPEvalue.Value;
TblRow["PEvalueoriginal"] = hdPEvalueoriginal.Value;
TblRow["PESides"] = hdPESides.Value;
TblRow["PESidesText"] = hdPESidesText.Value;
string strname = "", strleft = "", strright = "", strnormal = "", strcname = "", strcrom = "", strcnormal = "";
for (int i = 0; i < repROM.Items.Count; i++)
{
Label lblname = repROM.Items[i].FindControl("lblname") as Label;
TextBox txtleft = repROM.Items[i].FindControl("txtleft") as TextBox;
TextBox txtright = repROM.Items[i].FindControl("txtright") as TextBox;
TextBox txtnormal = repROM.Items[i].FindControl("txtnormal") as TextBox;
strname = strname + "," + lblname.Text;
strleft = strleft + "," + txtleft.Text;
strright = strright + "," + txtright.Text;
strnormal = strnormal + "," + txtnormal.Text;
}
TblRow["LeftROM"] = strleft.Substring(1);
TblRow["RightROM"] = strright.Substring(1);
TblRow["NormalROM"] = strnormal.Substring(1);
TblRow["NameROM"] = strname.Substring(1);
for (int i = 0; i < repROMCervical.Items.Count; i++)
{
Label lblname = repROMCervical.Items[i].FindControl("lblname") as Label;
TextBox txtrom = repROMCervical.Items[i].FindControl("txtrom") as TextBox;
TextBox txtnormal = repROMCervical.Items[i].FindControl("txtnormal") as TextBox;
strcname = strcname + "," + lblname.Text;
strcrom = strcrom + "," + txtrom.Text;
strcnormal = strcnormal + "," + txtnormal.Text;
}
if (!string.IsNullOrEmpty(strcname))
{
TblRow["CNameROM"] = strcname.Substring(1);
}
if (!string.IsNullOrEmpty(strcrom))
{
TblRow["CROM"] = strcrom.Substring(1);
}
if (!string.IsNullOrEmpty(strcnormal))
{
TblRow["CNormalROM"] = strcnormal.Substring(1);
}
if (_fuMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_fuMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (_fuMode == "New")
{
return("Neck has been added...");
}
else if (_fuMode == "Update")
{
return("Neck has been updated...");
}
else if (_fuMode == "Delete")
{
return("Neck has been deleted...");
}
else
{
return("");
}
}
public string SaveUI(string fuID, string ieMode, bool bpIsChecked)
{
_CurIEid = Session["PatientIE_ID2"].ToString();
_FuId = Session["patientFUId"].ToString();
long _fuID = Convert.ToInt64(_FuId);
string _fuMode = "";
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblFUbpOtherPart WHERE PatientFU_ID = " + _fuID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpIsChecked == true)
{
_fuMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpIsChecked == false)
{
_fuMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpIsChecked == false)
{
_fuMode = "Delete";
}
else
{
_fuMode = "Update";
}
if (_fuMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_fuMode == "Update" || _fuMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_fuMode == "Update" || _fuMode == "New")
{
TblRow["PatientFU_ID"] = _fuID;
TblRow["OthersCC"] = txtOthersCC.Text.ToString();
TblRow["OthersPE"] = txtOthersPE.Text.ToString();
TblRow["OthersA"] = txtOthersA.Text.ToString();
TblRow["OthersP"] = txtOthersP.Text.ToString();
TblRow["RecommandationDetails"] = Request.Form[txtTreatmentParagraph.UniqueID];
TblRow["RecommandationDelimit"] = bindTeratMentPrintvalue();
TblRow["PONDetails"] = Request.Form[txtPONDetails.UniqueID];
TblRow["PONDelimit"] = bindPONPrintValue();
TblRow["PONPrint"] = ViewState["PONPrint"].ToString();
if (_fuMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_fuMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (_fuMode == "New")
{
return("other part has been added...");
}
else if (_fuMode == "Update")
{
return("other part has been updated...");
}
else if (_fuMode == "Delete")
{
return("other part has been deleted...");
}
else
{
return("");
}
}
public string SaveUI(string fuID, string ieMode, bool bpChecked)
{
long _fuID = Convert.ToInt64(fuID);
string _ieMode = "";
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblFUbpMidBack WHERE PatientFU_ID = " + _fuID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["PatientFU_ID"] = _fuID;
//TblRow["PalpationAt"] = txtPalpationAt.Text.ToString();
//TblRow["Levels"] = cboLevels.Text.ToString();
//TblRow["ROM"] = cboROM.Text.ToString();
//TblRow["TPSide1"] = cboTPSide1.Text.ToString();
//TblRow["TPText1"] = txtTPText1.Text.ToString();
//TblRow["TPSide2"] = cboTPSide2.Text.ToString();
//TblRow["TPText2"] = txtTPText2.Text.ToString();
//TblRow["TPSide3"] = cboTPSide3.Text.ToString();
//TblRow["TPText3"] = txtTPText3.Text.ToString();
//TblRow["TPSide4"] = cboTPSide4.Text.ToString();
//TblRow["TPText4"] = txtTPText4.Text.ToString();
TblRow["FreeForm"] = txtFreeForm.Text.ToString();
//TblRow["FreeFormCC"] = txtFreeFormCC.Text.ToString();
TblRow["FreeFormA"] = txtFreeFormA.Text.ToString();
//TblRow["FreeFormP"] = txtFreeFormP.Text.ToString();
TblRow["CCvalue"] = hdCCvalue.Value;
TblRow["PEvalue"] = hdPEvalue.Value;
TblRow["PEvalueoriginal"] = hdPEvalueoriginal.Value;
TblRow["PESides"] = hdPESides.Value;
TblRow["PESidesText"] = hdPESidesText.Value;
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (_ieMode == "New")
{
return("MidBack has been added...");
}
else if (_ieMode == "Update")
{
return("MidBack has been updated...");
}
else if (_ieMode == "Delete")
{
return("MidBack has been deleted...");
}
else
{
return("");
}
}
public void SaveStdUI(string ieID, string iStdID, bool StdIsChecked, string bp, string shd, string scc, string spe, string sa, string sp, bool bcf, bool bpn)
{
string _ieMode = "";
long _ieID = Convert.ToInt64(ieID);
long _StdID = Convert.ToInt64(iStdID);
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblMacros WHERE PatientIE_ID = " + ieID + " AND Macro_Master_ID = " + _StdID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && StdIsChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && StdIsChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && StdIsChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["Macro_Master_ID"] = _StdID;
TblRow["PatientIE_ID"] = _ieID;
TblRow["BodayParts"] = bp.ToString().Trim();
TblRow["Heading"] = shd.ToString().Trim();
TblRow["CCDesc"] = scc.ToString().Trim();
TblRow["PEDesc"] = spe.ToString().Trim();
TblRow["ADesc"] = sa.ToString().Trim();
TblRow["PDesc"] = sp.ToString().Trim();
TblRow["CF"] = bcf;
TblRow["PN"] = bpn;
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
}
public void SaveMediUI(string ieID, string iMediID, bool MediIsChecked, string medi)
{
try
{
string _ieMode = "";
long _ieID = Convert.ToInt64(ieID);
long _MediID = Convert.ToInt64(iMediID);
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * FROM tblMedicationRx WHERE PatientIE_ID = " + ieID + " AND MedicationID = " + _MediID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && MediIsChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && MediIsChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && MediIsChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["MedicationID"] = _MediID;
TblRow["PatientIE_ID"] = _ieID;
TblRow["Medicine"] = medi.ToString().Trim();
if (_ieMode == "New")
{
TblRow["UpdatedBy"] = "Admin";
TblRow["UpdatedDateTime"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
}
catch (Exception ex)
{
log.Error(ex.Message);
}
}
public string SaveUI(string ieID, string ieMode, bool bpChecked)
{
try
{
long _ieID = Convert.ToInt64(ieID);
string _ieMode = "";
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblbpMidBack WHERE PatientIE_ID = " + ieID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["PatientIE_ID"] = _ieID;
//TblRow["FreeForm"] = txtFreeForm.Text.ToString();
//TblRow["FreeFormCC"] = txtFreeFormCC.Text.ToString();
TblRow["FreeFormA"] = txtFreeFormA.Text.ToString();
TblRow["FreeFormP"] = txtFreeFormP.Text.ToString();
TblRow["CCvalue"] = hdCCvalue.Value;
TblRow["PEvalue"] = hdPEvalue.Value;
TblRow["PEvalueoriginal"] = hdPEvalueoriginal.Value;
TblRow["PESides"] = hdPESides.Value;
TblRow["PESidesText"] = hdPESidesText.Value;
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (pageHDN.Value != null && pageHDN.Value != "")
{
Response.Redirect(pageHDN.Value.ToString());
}
if (_ieMode == "New")
{
return("MidBack has been added...");
}
else if (_ieMode == "Update")
{
return("MidBack has been updated...");
}
else if (_ieMode == "Delete")
{
return("MidBack has been deleted...");
}
else
{
return("");
}
}
catch (Exception ex)
{
}
return("");
}
public string SaveUI(string ieID, string ieMode, bool bpIsChecked)
{
long _ieID = Convert.ToInt64(ieID);
string _ieMode = "";
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblbpOtherPart WHERE PatientIE_ID = " + ieID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpIsChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpIsChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpIsChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["PatientIE_ID"] = _ieID;
TblRow["OthersCC"] = txtOthersCC.Text.ToString();
TblRow["OthersPE"] = txtOthersPE.Text.ToString();
TblRow["OthersA"] = txtOthersA.Text.ToString();
TblRow["OthersP"] = txtOthersP.Text.ToString();
TblRow["TreatMentDetails"] = Request.Form[txtTreatmentParagraph.UniqueID];
TblRow["TreatMentDelimit"] = bindTeratMentPrintvalue();
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (pageHDN.Value != null && pageHDN.Value != "")
{
Response.Redirect(pageHDN.Value.ToString());
}
if (_ieMode == "New")
{
return("Hip has been added...");
}
else if (_ieMode == "Update")
{
return("Hip has been updated...");
}
else if (_ieMode == "Delete")
{
return("Hip has been deleted...");
}
else
{
return("");
}
}
public string SaveUI(string ieID, string ieMode, bool bpIsChecked)
{
long _ieID = Convert.ToInt64(ieID);
string _ieMode = "";
string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString;
string SqlStr = "";
oSQLConn.ConnectionString = sProvider;
oSQLConn.Open();
SqlStr = "Select * from tblbpHip WHERE PatientIE_ID = " + ieID;
SqlDataAdapter sqlAdapt = new SqlDataAdapter(SqlStr, oSQLConn);
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
DataTable sqlTbl = new DataTable();
sqlAdapt.Fill(sqlTbl);
DataRow TblRow;
if (sqlTbl.Rows.Count == 0 && bpIsChecked == true)
{
_ieMode = "New";
}
else if (sqlTbl.Rows.Count == 0 && bpIsChecked == false)
{
_ieMode = "None";
}
else if (sqlTbl.Rows.Count > 0 && bpIsChecked == false)
{
_ieMode = "Delete";
}
else
{
_ieMode = "Update";
}
if (_ieMode == "New")
{
TblRow = sqlTbl.NewRow();
}
else if (_ieMode == "Update" || _ieMode == "Delete")
{
TblRow = sqlTbl.Rows[0];
TblRow.AcceptChanges();
}
else
{
TblRow = null;
}
if (_ieMode == "Update" || _ieMode == "New")
{
TblRow["PatientIE_ID"] = _ieID;
//TblRow["ConstantLeft"] = chkContentLeft.Checked;
//TblRow["IntermittentLeft"] = chkIntermittentLeft.Checked;
//TblRow["ConstantRight"] = chkContentRight.Checked;
//TblRow["IntermittentRight"] = chkIntermittentRight.Checked;
//TblRow["WorseSittingLeft"] = chkWorseSittingLeft.Checked;
//TblRow["WorseStandingLeft"] = chkWorseStandingLeft.Checked;
//TblRow["WorseMovementLeft"] = chkWorseMovementLeft.Checked;
//TblRow["WorseActivitiesLeft"] = chkWorseActivitiesLeft.Checked;
//TblRow["WorseOtherLeft"] = txtWorseOtherLeft.Text.ToString();
//TblRow["WorseSittingRight"] = chkWorseSittingRight.Checked;
//TblRow["WorseStandingRight"] = chkWorseStandingRight.Checked;
//TblRow["WorseMovementRight"] = chkWorseMovementRight.Checked;
//TblRow["WorseActivitiesRight"] = chkWorseActivitiesRight.Checked;
//TblRow["WorseOtherRight"] = txtWorseOtherRight.Text.ToString();
//TblRow["GreaterTrochanterLeft"] = chkGreaterTrochanterLeft.Checked;
//TblRow["PosteriorLeft"] = chkPosteriorLeft.Checked;
//TblRow["IliotibialLeft"] = chkIliotibialLeft.Checked;
//TblRow["GreaterTrochanterRight"] = chkGreaterTrochanterRight.Checked;
//TblRow["PosteriorRight"] = chkPosteriorRight.Checked;
//TblRow["IliotibialRight"] = chkIliotibialRight.Checked;
TblRow["FlexRight"] = txtFlexRight.Text.ToString();
TblRow["IntRotationRight"] = txtIntRotationRight.Text.ToString();
TblRow["ExtRotationRight"] = txtExtRotationRight.Text.ToString();
TblRow["FlexLeft"] = txtFlexLeft.Text.ToString();
TblRow["IntRotationLeft"] = txtIntRotationLeft.Text.ToString();
TblRow["ExtRotationLeft"] = txtExtRotationLeft.Text.ToString();
TblRow["FlexNormal"] = txtFlexNormal.Text.ToString();
TblRow["IntRotationNormal"] = txtIntRotationNormal.Text.ToString();
TblRow["ExtRotationNormal"] = txtExtRotationNormal.Text.ToString();
TblRow["FreeFormA"] = txtFreeFormA.Text.ToString();
TblRow["FreeFormP"] = txtFreeFormP.Text.ToString();
TblRow["CCvalue"] = hdCCvalue.Value;
string strname = "", strleft = "", strright = "", strnormal = "";
for (int i = 0; i < repROM.Items.Count; i++)
{
Label lblname = repROM.Items[i].FindControl("lblname") as Label;
TextBox txtleft = repROM.Items[i].FindControl("txtleft") as TextBox;
TextBox txtright = repROM.Items[i].FindControl("txtright") as TextBox;
TextBox txtnormal = repROM.Items[i].FindControl("txtnormal") as TextBox;
strname = strname + "," + lblname.Text;
strleft = strleft + "," + txtleft.Text;
strright = strright + "," + txtright.Text;
strnormal = strnormal + "," + txtnormal.Text;
}
TblRow["LeftROM"] = strleft.Substring(1);
TblRow["RightROM"] = strright.Substring(1);
TblRow["NormalROM"] = strnormal.Substring(1);
TblRow["NameROM"] = strname.Substring(1);
TblRow["PEvalue"] = hdPEvalue.Value;
if (_ieMode == "New")
{
TblRow["CreatedBy"] = "Admin";
TblRow["CreatedDate"] = DateTime.Now;
sqlTbl.Rows.Add(TblRow);
}
sqlAdapt.Update(sqlTbl);
}
else if (_ieMode == "Delete")
{
TblRow.Delete();
sqlAdapt.Update(sqlTbl);
}
if (TblRow != null)
{
TblRow.Table.Dispose();
}
sqlTbl.Dispose();
sqlCmdBuilder.Dispose();
sqlAdapt.Dispose();
oSQLConn.Close();
if (pageHDN.Value != null && pageHDN.Value != "")
{
Response.Redirect(pageHDN.Value.ToString());
}
if (_ieMode == "New")
{
return("Hip has been added...");
}
else if (_ieMode == "Update")
{
return("Hip has been updated...");
}
else if (_ieMode == "Delete")
{
return("Hip has been deleted...");
}
else
{
return("");
}
}