protected void lnkDelete_Click(object sender, EventArgs e) { DBHelperClass db = new DBHelperClass(); try { LinkButton lnkdelete = sender as LinkButton; string SP = "delete from tbl_designation where id=" + lnkdelete.CommandArgument; int val = db.executeQuery(SP); if (val > 0) { bindGroupsDetails(1); divSuccess.Attributes.Add("style", "display:block"); divfail.Attributes.Add("style", "display:none"); } else { divSuccess.Attributes.Add("style", "display:none"); divfail.Attributes.Add("style", "display:block"); } } catch (Exception ex) { log.Error(ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (fup.HasFiles) { string upload_folder_path = "~/PatientDocument/" + Session["PatientId"]; if (!Directory.Exists(upload_folder_path)) { Directory.CreateDirectory(Server.MapPath(upload_folder_path)); } foreach (HttpPostedFile uploadedFile in fup.PostedFiles) { string filename = uploadedFile.FileName; string doa = CommonConvert.DateFormat(ViewState["doa"].ToString()); //string filename = System.DateTime.Now.Millisecond.ToString() + "_" + uploadedFile.FileName; string query = "insert into tblPatientDocument values('" + filename + "','" + System.DateTime.Now.ToString() + "','" + upload_folder_path + "/" + filename + "'," + Session["PatientId"].ToString() + ",'" + Request["DOA"].ToString() + "')"; db.executeQuery(query); uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath(upload_folder_path), filename)); // listofuploadedfiles.Text += String.Format("{0}<br />", uploadedFile.FileName); } } getData(); } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { DBHelperClass db = new DBHelperClass(); try { string SP = ""; SqlParameter[] param = null; if (Request["id"] != null) { param = new SqlParameter[10]; SP = "update tbl_designation set Designation='" + txtDesignation.Text + "' where id=" + Request["id"]; } else { param = new SqlParameter[10]; SP = "insert into tbl_designation values('" + txtDesignation.Text + "')"; } int val = db.executeQuery(SP); if (val > 0) { Response.Redirect("ViewDesignation.aspx"); } } catch (Exception ex) { } }
public void Reschedules(string id) { DBHelperClass dBHelper = new DBHelperClass(); string query = "update tblProceduresDetail set Scheduled=null where ProcedureDetail_ID=" + id; dBHelper.executeQuery(query); BindProcudureList(); }
public void TransferToExecute(string id, string sDate) { if (!string.IsNullOrEmpty(sDate)) { DBHelperClass dBHelper = new DBHelperClass(); string query = "update tblProceduresDetail set Executed='" + sDate + "',Scheduled=null where ProcedureDetail_ID=" + id; dBHelper.executeQuery(query); } }
protected void btnDelete_Click(object sender, EventArgs e) { DBHelperClass db = new DBHelperClass(); Button btn = sender as Button; string query = "delete from tblPatientDocument where Document_ID=" + btn.CommandArgument; db.executeQuery(query); getData(); }
protected void btnSignUpload_Click(object sender, EventArgs e) { foreach (HttpPostedFile postedFile in fupsign.PostedFiles) { //string[] fileName = Path.GetFileName(postedFile.FileName).Split(','); string fileName = Path.GetFileName(postedFile.FileName); string msg = ""; try { string upload_folder_path = "~/Sign/"; string fullpath = System.IO.Path.Combine(Server.MapPath(upload_folder_path), fileName); postedFile.SaveAs(fullpath); sb.Append("<p>File Name : " + fileName + " patientIEId:" + fileName.Split('_')[0] + " Status : Uploaded </p>"); sb.Append(Environment.NewLine); Logger.Info("File Name : " + fileName + " patientIEId:" + fileName.Split('_')[0] + " Status : Uploaded"); string query = ""; if (!string.IsNullOrEmpty(fileName.Split('_')[0])) { query = "delete from tblPatientIESign where PatientIE_ID=" + fileName.Split('_')[0]; db.executeQuery(query); query = "insert into tblPatientIESign values(" + fileName.Split('_')[0] + ",'" + fullpath + "',null,null,getdate(),0)"; db.executeQuery(query); } } catch (Exception ex) { sb.Append("<p style='color:red'>File Name : " + fileName + " Status : Not Uploaded </p>"); Logger.Error("File Name : " + fileName + " Status : Not Uploaded \n"); } } lblResult.InnerHtml = sb.ToString(); }
protected void btnSave_Click(object sender, EventArgs e) { string query = "select Password from tblUserMaster where (LoginID=@uname or eMailID=@uname)"; SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString); SqlCommand cm = new SqlCommand(query, cn); cm.Parameters.AddWithValue("@uname", txt_uname.Text); SqlDataAdapter da = new SqlDataAdapter(cm); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Password"].ToString() == txt_pass.Text) { //Change the password and redirect next page DBHelperClass db = new DBHelperClass(); query = "UPDATE tblUserMaster SET Password = '******' WHERE LoginID = '" + txt_uname.Text.ToString() + "'"; int val = db.executeQuery(query); if (val > 0) { Session["uname"] = txt_uname.Text; lblMessage.InnerHtml = "Password has been changed successfuly."; lblMessage.Attributes.Add("style", "color:green"); upMessage.Update(); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "openPopup('mymodelmessage')", true); Response.Redirect("PatientIntakeList.aspx"); } } else { lblmess.Attributes.Add("style", "display:block"); } } else { lblmess.Attributes.Add("style", "display:block"); } }
protected void btnSave_Click(object sender, EventArgs e) { DBHelperClass db = new DBHelperClass(); try { string query = "", strmcode = "", position = ""; for (int i = 0; i < chkProcExe.Items.Count; i++) { if (chkProcExe.Items[i].Selected) { strmcode = strmcode + "," + chkProcExe.Items[i].Text; } } if (ddlbodypart.SelectedValue.ToLower() != "neck" || ddlbodypart.SelectedValue.ToLower() != "midback" || ddlbodypart.SelectedValue.ToLower() != "lowback") { position = ddlposition.SelectedValue; } if (Request["id"] == null) { query = "insert into tblProcedureStatus values('" + ddlProcSchedule.SelectedValue + "','" + strmcode.TrimStart(',') + "','" + ddlbodypart.SelectedValue + "','" + position + "')"; } else { query = " update tblProcedureStatus set Procedures='" + ddlProcSchedule.SelectedValue + "',PreRequest='" + strmcode.TrimStart(',') + "',BodyPart='" + ddlbodypart.SelectedValue + "',Position='" + ddlposition.SelectedValue + "' where id=" + Request["id"]; } int val = db.executeQuery(query); if (val > 0) { Response.Redirect("ViewProcConstraint.aspx"); } } catch (Exception ex) { log.Error(ex.Message); } }
protected void lnkDelete_Click(object sender, EventArgs e) { DBHelperClass db = new DBHelperClass(); try { LinkButton lnkdelete = sender as LinkButton; string SP = "delete from tblUserMaster where User_ID=" + lnkdelete.CommandArgument; db.executeQuery(SP); //if (val > 0) //{ BindUserDetails(1); divSuccess.Attributes.Add("style", "display:block"); divfail.Attributes.Add("style", "display:none"); } catch (Exception ex) { divSuccess.Attributes.Add("style", "display:none"); divfail.Attributes.Add("style", "display:block"); log.Error(ex.Message); } }
protected void btnupload_mul_Click(object sender, EventArgs e) { DBHelperClass dBHelperClass = new DBHelperClass(); DataSet dataSet = new DataSet(); string fname = "", lname = "", doa = ""; foreach (HttpPostedFile postedFile in fupmul.PostedFiles) { //string[] fileName = Path.GetFileName(postedFile.FileName).Split(','); string fileName = Path.GetFileName(postedFile.FileName); string msg = ""; try { Regex re = new Regex(@"\d+"); Match m = re.Match(fileName); if (m.Success) { string file = fileName.Substring(0, m.Index); string[] str = file.Split(','); // lblResults.Text = string.Format("RegEx found " + m.Value + " at position " + m.Index.ToString() + " character in string is " + file + " fname: " + str[1] + ",LastName:" + str[0]); lname = str[0]; if (str[1].Contains("_")) { fname = str[1].Split('_')[0]; } else { fname = str[1]; } file = fileName; str = file.Split('_'); if (str.Length > 2) { doa = str[str.Length - 1].ToLower().Split('.')[0]; } } else { string[] str = fileName.Split('_'); fname = str[0].Split(',')[1]; lname = str[0].Split(',')[0]; } doa = CommonConvert.DateformatDOA(doa); doa = CommonConvert.DateFormat(doa); string[] strfname = fname.TrimStart().Split(' '); fname = strfname[0]; dataSet = dBHelperClass.selectData("select Patient_ID from tblPatientMaster where LastName='" + lname.Trim().TrimStart() + "' and FirstName='" + fname.Trim().TrimStart() + "'"); if (dataSet != null && dataSet.Tables[0].Rows.Count > 0) { string patientid = dataSet.Tables[0].Rows[0][0].ToString(); string upload_folder_path = "~/PatientDocument/" + patientid; if (!Directory.Exists(upload_folder_path)) { Directory.CreateDirectory(Server.MapPath(upload_folder_path)); } postedFile.SaveAs(System.IO.Path.Combine(Server.MapPath(upload_folder_path), fileName)); sb.Append("<p>File Name : " + fileName + " patientid:" + patientid + " Status : Uploaded </p>"); sb.Append(Environment.NewLine); Logger.Info("File Name : " + fileName + " patientid:" + patientid + " Status : Uploaded"); //string filename = System.DateTime.Now.Millisecond.ToString() + "_" + fileName; if (checkName(fileName, patientid) == false) { string filename = fileName; string query = "insert into tblPatientDocument values('" + filename + "','" + System.DateTime.Now.ToString() + "','" + upload_folder_path + "/" + filename + "'," + patientid + ",'" + doa + "')"; dBHelperClass.executeQuery(query); } } else { sb.Append("<p style='color:red'> File Name : " + fileName + " Status : Not Uploaded</p>"); sb.Append(Environment.NewLine); Logger.Info("File Name : " + fileName + " Status : Not Uploaded"); } } catch (Exception ex) { sb.Append("<p style='color:red'>File Name : " + fileName + " Status : Not Uploaded </p>"); Logger.Error("File Name : " + fileName + " Status : Not Uploaded \n"); } lblResult.InnerHtml = sb.ToString(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { DBHelperClass db = new DBHelperClass(); string query = ""; //query = "update tblPatientIEDetailPage1 set FreeForm='" + txt_FreeForm.Text + "' where PatientIE_ID=" + Session["PatientIE_ID"].ToString(); //int val = db.executeQuery(query); //if (val > 0) //{ query = "select top 1 * from tblPatientIEDetailPage2 where PatientIE_ID=" + Session["PatientIE_ID"].ToString(); DataSet ds = db.selectData(query); if (ds.Tables[0].Rows.Count == 0) { query = "insert into tblPatientIEDetailPage2 ("; query = query + "intactexcept,LEdtr,DTRtricepsRight,DTRtricepsLeft,DTRBicepsRight,DTRBicepsLeft,DTRBrachioRight,DTRBrachioLeft,UEdtr,DTRKneeLeft,DTRKneeRight,DTRAnkleLeft,DTRAnkleRight,Sensory,PinPrick,Lighttouch,"; query = query + "LEsen,LEL3Right,LEL3Left,LEL4Right,LEL4Left,LEL5Right,LEL5Left,LES1Left,LES1Right,LELumberParaspinalsLeft,LELumberParaspinalsRight,UEsen,UEC5Left,UEC5Right,UEC6Left,UEC6Right,UEC7Left,UEC7Right,UEC8Left,UEC8Right,UET1Right,UET1Left,UECervicalParaspinalsRight,UECervicalParaspinalsLeft,"; query = query + "LEmmst,LEHipFlexionRight,LEHipFlexionLeft,LEHipAbductionRight,LEHipAbductionLeft,LEKneeExtensionRight,LEKneeExtensionLeft,LEKneeFlexionRight,LEKneeFlexionLeft,LEAnkleDorsiRight,LEAnkleDorsiLeft,LEAnklePlantarRight,LEAnklePlantarLeft,LEAnkleExtensorRight,LEAnkleExtensorLeft,"; query = query + "UEmmst,UEShoulderAbductionRight,UEShoulderAbductionLeft,UEShoulderFlexionRight,UEShoulderFlexionLeft,UEElbowExtensionRight,UEElbowExtensionLeft,UEElbowFlexionRight,UEElbowFlexionLeft,UEElbowSupinationRight,UEElbowSupinationLeft,UEElbowPronationRight,UEElbowPronationLeft,UEWristFlexionRight,UEWristFlexionLeft,UEWristExtensionRight,UEWristExtensionLeft,UEHandGripStrengthRight,UEHandGripStrengthLeft,UEHandFingerAbductorsRight,UEHandFingerAbductorsLeft"; query = query + ") values ("; query = query + "'" + txtIntactExcept.Text + "','" + LEdtr.Checked + "','" + RTricepstxt.Text + "','" + LTricepstxt.Text + "','" + RBicepstxt.Text + "','" + LBicepstxt.Text + "','" + RBrachioradialis.Text + "','" + LBrachioradialis.Text + "','" + UExchk.Checked + "','" + LKnee.Text + "','" + RKnee.Text + "','" + LAnkle.Text + "','" + RAnkle.Text + "','" + txtSensory.Text.Replace("'", "''") + "','" + chkPinPrick.Checked + "','" + chkLighttouch.Checked + "',"; query = query + "'" + LESen_Click.Checked + "','" + TextBox4.Text + "','" + txtDMTL3.Text + "','" + TextBox6.Text + "','" + TextBox5.Text + "','" + TextBox8.Text + "','" + TextBox7.Text + "','" + TextBox10.Text + "','" + TextBox21.Text + "','" + TextBox24.Text + "','" + TextBox25.Text + "','" + UESen_Click.Checked + "','" + TextBox9.Text + "','" + txtUEC5Right.Text + "','" + TextBox11.Text + "','" + TextBox12.Text + "','" + TextBox13.Text + "','" + TextBox14.Text + "','" + TextBox15.Text + "','" + TextBox16.Text + "','" + TextBox18.Text + "','" + TextBox17.Text + "','" + TextBox20.Text + "','" + TextBox19.Text + "',"; query = query + "'" + LEmmst.Checked + "','" + TextBox23.Text + "','" + TextBox22.Text + "','" + TextBox41.Text + "','" + TextBox40.Text + "','" + TextBox27.Text + "','" + TextBox26.Text + "','" + TextBox43.Text + "','" + TextBox42.Text + "','" + TextBox29.Text + "','" + TextBox28.Text + "','" + TextBox45.Text + "','" + TextBox44.Text + "','" + TextBox47.Text + "','" + TextBox46.Text + "',"; query = query + "'" + UEmmst.Checked + "','" + TextBox31.Text + "','" + TextBox30.Text + "','" + TextBox49.Text + "','" + TextBox48.Text + "','" + TextBox33.Text + "','" + TextBox32.Text + "','" + TextBox51.Text + "','" + TextBox50.Text + "','" + TextBox53.Text + "','" + TextBox52.Text + "','" + TextBox55.Text + "','" + TextBox54.Text + "','" + TextBox37.Text + "','" + TextBox36.Text + "','" + TextBox57.Text + "','" + TextBox56.Text + "','" + TextBox39.Text + "','" + TextBox38.Text + "','" + TextBox59.Text + "','" + TextBox58.Text + "')"; } else { query = "update tblPatientIEDetailPage2 set "; query = query + "intactexcept='" + txtIntactExcept.Text + "',LEdtr = '" + LEdtr.Checked + "',DTRtricepsRight = '" + RTricepstxt.Text + "',DTRtricepsLeft ='" + LTricepstxt.Text + "',DTRBicepsRight ='" + RBicepstxt.Text + "',DTRBicepsLeft = '" + LBicepstxt.Text + "',DTRBrachioRight ='" + RBrachioradialis.Text + "',DTRBrachioLeft = '" + LBrachioradialis.Text + "' ,UEdtr = '" + UExchk.Checked + "',DTRKneeLeft = '" + LKnee.Text + "',DTRKneeRight = '" + RKnee.Text + "',DTRAnkleLeft = '" + LAnkle.Text + "' ,DTRAnkleRight = '" + RAnkle.Text + "',Sensory = '" + txtSensory.Text.Replace("'", "''") + "',PinPrick = '" + chkPinPrick.Checked + "',Lighttouch = '" + chkLighttouch.Checked + "',"; query = query + "LEsen = '" + LESen_Click.Checked + "',LEL3Right = '" + TextBox4.Text + "',LEL3Left = '" + txtDMTL3.Text + "',LEL4Right = '" + TextBox6.Text + "',LEL4Left = '" + TextBox5.Text + "',LEL5Right = '" + TextBox8.Text + "',LEL5Left = '" + TextBox7.Text + "',LES1Left = '" + TextBox10.Text + "',LES1Right = '" + TextBox21.Text + "',LELumberParaspinalsLeft = '" + TextBox24.Text + "',LELumberParaspinalsRight = '" + TextBox25.Text + "',UEsen ='" + UESen_Click.Checked + "',UEC5Left = '" + TextBox9.Text + "',UEC5Right = '" + txtUEC5Right.Text + "',UEC6Left = '" + TextBox11.Text + "',UEC6Right = '" + TextBox12.Text + "',UEC7Left = '" + TextBox13.Text + "',UEC7Right = '" + TextBox14.Text + "',UEC8Left = '" + TextBox15.Text + "',UEC8Right = '" + TextBox16.Text + "',UET1Right = '" + TextBox18.Text + "',UET1Left = '" + TextBox17.Text + "',UECervicalParaspinalsRight = '" + TextBox20.Text + "',UECervicalParaspinalsLeft = '" + TextBox19.Text + "',"; query = query + "LEmmst = '" + LEmmst.Checked + "',LEHipFlexionRight = '" + TextBox23.Text + "',LEHipFlexionLeft = '" + TextBox22.Text + "',LEHipAbductionRight = '" + TextBox41.Text + "',LEHipAbductionLeft = '" + TextBox40.Text + "',LEKneeExtensionRight = '" + TextBox27.Text + "',LEKneeExtensionLeft = '" + TextBox26.Text + "',LEKneeFlexionRight = '" + TextBox43.Text + "',LEKneeFlexionLeft = '" + TextBox42.Text + "',LEAnkleDorsiRight = '" + TextBox29.Text + "',LEAnkleDorsiLeft = '" + TextBox28.Text + "',LEAnklePlantarRight = '" + TextBox45.Text + "',LEAnklePlantarLeft = '" + TextBox44.Text + "',LEAnkleExtensorRight = '" + TextBox47.Text + "',LEAnkleExtensorLeft = '" + TextBox46.Text + "',"; query = query + "UEmmst = '" + UEmmst.Checked + "',UEShoulderAbductionRight = '" + TextBox31.Text + "',UEShoulderAbductionLeft = '" + TextBox30.Text + "',UEShoulderFlexionRight = '" + TextBox49.Text + "',UEShoulderFlexionLeft = '" + TextBox48.Text + "',UEElbowExtensionRight = '" + TextBox33.Text + "',UEElbowExtensionLeft = '" + TextBox32.Text + "',UEElbowFlexionRight = '" + TextBox51.Text + "',UEElbowFlexionLeft = '" + TextBox50.Text + "',UEElbowSupinationRight = '" + TextBox53.Text + "',UEElbowSupinationLeft = '" + TextBox52.Text + "',UEElbowPronationRight = '" + TextBox55.Text + "',UEElbowPronationLeft = '" + TextBox54.Text + "',UEWristFlexionRight = '" + TextBox37.Text + "',UEWristFlexionLeft = '" + TextBox36.Text + "',UEWristExtensionRight = '" + TextBox57.Text + "',UEWristExtensionLeft = '" + TextBox56.Text + "',UEHandGripStrengthRight = '" + TextBox39.Text + "',UEHandGripStrengthLeft = '" + TextBox38.Text + "',UEHandFingerAbductorsRight = '" + TextBox59.Text + "',UEHandFingerAbductorsLeft = '" + TextBox58.Text + "'"; query = query + " Where PatientIE_ID=" + Session["PatientIE_ID"].ToString() + ""; } ds.Dispose(); int val = db.executeQuery(query); query = "select top 1 * from tblPage3HTMLContent where PatientIE_ID=" + Session["PatientIE_ID"].ToString(); ds = db.selectData(query); if (ds.Tables[0].Rows.Count == 0) { query = "insert into tblPage3HTMLContent(PatientIE_ID,HTMLContent,topSectionHTML)values(@PatientIE_ID,@HTMLContent,@topSectionHTML)"; } else { query = "update tblPage3HTMLContent set HTMLContent=@HTMLContent,topSectionHTML=@topSectionHTML where PatientIE_ID=@PatientIE_ID"; } using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString)) using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("@PatientIE_ID", Session["PatientIE_ID"].ToString()); command.Parameters.AddWithValue("@HTMLContent", hdHTMLContent.Value); command.Parameters.AddWithValue("@topSectionHTML", hdtopHTMLContent.Value); connection.Open(); var results = command.ExecuteNonQuery(); connection.Close(); } if (val > 0) { try { long _ieID = Convert.ToInt64(Session["PatientIE_ID"].ToString()); string _ieMode = ""; string sProvider = ConfigurationManager.ConnectionStrings["connString_V3"].ConnectionString; string SqlStr = ""; oSQLConn.ConnectionString = sProvider; oSQLConn.Open(); SqlStr = "Select * from tblPatientIEDetailPage3 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) { _ieMode = "New"; } else if (sqlTbl.Rows.Count > 0) { _ieMode = "Update"; } if (_ieMode == "New") { TblRow = sqlTbl.NewRow(); } else if (_ieMode == "Update") { TblRow = sqlTbl.Rows[0]; TblRow.AcceptChanges(); } else { TblRow = null; } if (_ieMode == "Update" || _ieMode == "New") { TblRow["PatientIE_ID"] = _ieID; TblRow["GAIT"] = cboGAIT.Text.ToString(); TblRow["Ambulates"] = cboAmbulates.Text.ToString(); TblRow["Footslap"] = chkFootslap.Checked; TblRow["Kneehyperextension"] = chkKneehyperextension.Checked; TblRow["Unabletohealwalk"] = chkUnabletohealwalk.Checked; TblRow["Unabletotoewalk"] = chkUnabletotoewalk.Checked; TblRow["Other"] = txtOther.Text.ToString(); if (_ieMode == "New") { TblRow["CreatedBy"] = "Admin"; TblRow["CreatedDate"] = DateTime.Now; sqlTbl.Rows.Add(TblRow); } sqlAdapt.Update(sqlTbl); } if (TblRow != null) { TblRow.Table.Dispose(); } sqlTbl.Dispose(); sqlCmdBuilder.Dispose(); sqlAdapt.Dispose(); oSQLConn.Close(); } catch (Exception ex) { oSQLConn.Close(); } } ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "openPopup('mymodelmessage')", true); Logger.Info(Session["UserId"].ToString() + "--" + Session["uname"].ToString().Trim() + "-- Create IE - Page4 " + Session["PatientIE_ID"].ToString() + "--" + DateTime.Now); if (pageHDN.Value != null && pageHDN.Value != "") { Response.Redirect(pageHDN.Value.ToString()); } else { Response.Redirect("Page5.aspx"); } } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { try { string query = "", locations = "", locations_id = "", page_id = "", pages = "", reports = "", roleid = ""; for (int i = 0; i < chkLocations.Items.Count; i++) { if (chkLocations.Items[i].Selected) { locations = locations + "," + chkLocations.Items[i].Text; locations_id = locations_id + "," + chkLocations.Items[i].Value; } } for (int i = 0; i < chkPages.Items.Count; i++) { if (chkPages.Items[i].Selected) { pages = pages + "," + chkPages.Items[i].Text; page_id = page_id + "," + chkPages.Items[i].Value; } } for (int i = 0; i < chkReports.Items.Count; i++) { if (chkReports.Items[i].Selected) { reports = reports + "," + chkReports.Items[i].Text; } } for (int i = 0; i < chkRole.Items.Count; i++) { if (chkRole.Items[i].Selected) { roleid = roleid + "," + chkRole.Items[i].Value; } } if (Request["id"] != null) { query = "update tblGroups set Name='" + txtName.Text + "',"; query = query + " page_id='" + page_id.TrimStart(',') + "',pages='" + pages.TrimStart(',') + "',"; query = query + " locations_id='" + locations_id.TrimStart(',') + "',locations='" + locations.TrimStart(',') + "',reports='" + reports.TrimStart(',') + "',role_id='" + roleid.TrimStart(',') + "' where Id=" + Request["id"].ToString(); } else { query = "insert into tblGroups(Name,locations_id,locations,page_id,pages,reports,role_id) values('" + txtName.Text + "',"; query = query + " '" + locations_id.TrimStart(',') + "','" + locations.TrimStart(',') + "','" + page_id.TrimStart(',') + "','" + pages.TrimStart(',') + "','" + reports.TrimStart(',') + "','" + roleid.TrimStart(',') + "') "; } db.executeQuery(query); Response.Redirect("ViewGroups.aspx"); } catch (Exception ex) { } }
protected void btnSave_Click(object sender, EventArgs e) { string query = ""; if (ViewState["patientIEid"] == null) { query = "insert into dbo.tblPatientIEDetailPage1("; query = query + "PatientIE_ID,Sustained,Position,InvolvedIn,EMSTeam,WentTo,Via,HadXrayOf,HadCTScanOf,"; query = query + " PrescriptionFor,FreeForm,InjuryToHead,HadMRIOf)"; query = query + "values(" + Session["PatientIE_ID"].ToString() + ",'" + ddl_accident_desc.Text + "','" + ddl_belt.Text + "','" + ddl_invovledin.Text + "',"; query = query + "'" + ddl_EMS.Text + "','" + txt_hospital.Text + "','" + ddl_via.Text + "','" + txt_x_ray.Value + "',"; query = query + "'" + txt_CT.Value + "','" + txt_prescription.Value + "','" + txt_which_what.Value + "','" + chk_headinjury.Checked + "','" + txt_mri.Value + "')"; } else { query = "update tblPatientIEDetailPage1 set "; query = query + "Sustained='" + ddl_accident_desc.Text + "',Position='" + ddl_belt.Text + "',"; query = query + "InvolvedIn='" + ddl_invovledin.Text + "',EMSTeam='" + ddl_EMS.Text + "',WentTo='" + txt_hospital.Text + "',Via='" + ddl_via.Text + "',"; query = query + "HadXrayOf='" + txt_x_ray.Value + "',HadCTScanOf='" + txt_CT.Value + "',"; query = query + " PrescriptionFor='" + txt_prescription.Value + "',FreeForm='" + txt_which_what.Value + "',InjuryToHead='" + chk_headinjury.Checked + "',"; query = query + " HadMRIOf='" + txt_mri.Value + "' where PatientIE_ID=" + ViewState["patientIEid"].ToString(); } int lresult = gDbhelperobj.executeQuery(query); if (lresult > 0) { if (ViewState["patientIEid"] == null) { query = "insert into tblInjuredBodyParts(PatientIE_ID,Neck,MidBack,LowBack,"; query = query + "LeftShoulder,RightShoulder,LeftKnee,RightKnee,LeftElbow,RightElbow,"; query = query + "LeftWrist,RightWrist,LeftAnkle,RightAnkle,Others)values"; query = query + "(" + Session["PatientIE_ID"].ToString() + ",'" + chk_Neck.Checked + "','" + chk_Midback.Checked + "','" + chk_lowback.Checked + "',"; query = query + "'" + chk_L_Shoulder.Checked + "','" + chk_r_Shoulder.Checked + "','" + chk_L_Keen.Checked + "','" + chk_r_Keen.Checked + "',"; query = query + "'" + chk_l_Elbow.Checked + "','" + chk_r_Elbow.Checked + "','" + chk_l_Wrist.Checked + "','" + chk_r_Wrist.Checked + "',"; query = query + "'" + chk_l_ankle.Checked + "','" + chk_r_ankle.Checked + "','" + txt_other.Value + "')"; } else { query = "update tblInjuredBodyParts set Neck='" + chk_Neck.Checked + "',MidBack='" + chk_Midback.Checked + "',LowBack='" + chk_lowback.Checked + "',"; query = query + "LeftShoulder='" + chk_L_Shoulder.Checked + "',RightShoulder='" + chk_r_Shoulder.Checked + "',LeftKnee='" + chk_L_Keen.Checked + "',RightKnee='" + chk_r_Keen.Checked + "',"; query = query + "LeftElbow='" + chk_l_Elbow.Checked + "',RightElbow='" + chk_r_Elbow.Checked + "',"; query = query + "LeftWrist='" + chk_l_Wrist.Checked + "',RightWrist='" + chk_r_Wrist.Checked + "',LeftAnkle='" + chk_l_ankle.Checked + "',"; query = query + " RightAnkle='" + chk_r_ankle.Checked + "',Others='" + txt_other.Value + "' where PatientIE_ID=" + ViewState["patientIEid"].ToString(); } lresult = gDbhelperobj.executeQuery(query); if (lresult > 0) { if (ViewState["patientIEid"] == null) { lblMessage.InnerHtml = "Data Save successfuly."; } else { lblMessage.InnerHtml = "Data Updated successfuly."; } lblMessage.Attributes.Add("style", "color:green"); upMessage.Update(); } else { lblMessage.InnerHtml = "Sorry,there may be same error."; lblMessage.Attributes.Add("style", "color:red"); } } else { lblMessage.InnerHtml = "Sorry,there may be same error."; lblMessage.Attributes.Add("style", "color:red"); } ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), Guid.NewGuid().ToString(), "openPopup('mymodelmessage')", true); }