private void RefreshData() { string strSql = " SELECT id, firstname || ' ' || lastname as Name " + " FROM login where isdoctor = false and isadmin=false " + " and isnewuser=true order by Name"; DataSet ds = BaseDA.ExecuteDataSet(strSql); gvHist.DataSource = ds; gvHist.DataBind(); if (ds != null) { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { gvHist.DataSource = ds.Tables[0]; gvHist.DataBind(); } else { gvHist.Visible = false; this.ErrorMessage += "No Results Found"; } } else { this.ErrorMessage += "DataSet is null"; } }
protected void btnRemarks_Click(object sender, System.EventArgs e) { try { if (string.IsNullOrEmpty(txtRemarks.Text.Trim())) { this.ErrorMessage += "Remarks is Required <br />"; } else { //Save Remarks string strSql = string.Format("Update doctorpatient set doctorremarks='{0}' where " + "doctorid = {1} and patientid = {2} ", BaseDA.Escape(txtRemarks.Text.Trim()), this.UserId, this.SelectedPId); BaseDA.ExecuteNonQuery(strSql); phRemarks.Visible = false; this.SelectedPId = 0; } } catch (Exception ex) { this.ErrorMessage = ex.Message; } }
protected void btnlogin_Click(object sender, EventArgs e) { try { // Checking for Required Fields if (string.IsNullOrEmpty(txtuser.Text.Trim())) { this.ErrorMessage += "User Name is Required <br />"; } if (string.IsNullOrEmpty(txtpassword.Text.Trim())) { this.ErrorMessage += "Password is Required<br />"; } //Checking for Errors if (string.IsNullOrEmpty(this.ErrorMessage)) { DataSet ds = BaseDA.ExecuteDataSet(string.Format("select * from login where username = '******' and password ='******'", BaseDA.Escape(txtuser.Text), BaseDA.Escape(txtpassword.Text))); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; if (dr != null) { if (dr["Id"] != null) { this.UserId = Convert.ToInt32(dr["Id"]); this.UserName = dr["lastname"].ToString() + " " + dr["firstname"].ToString(); this.IsAdmin = Convert.ToBoolean(dr["isadmin"]); this.IsDoctor = Convert.ToBoolean(dr["isdoctor"]); } } } if (this.UserId > 0) { if (IsDoctor) { Response.Redirect("DoctorsPage.aspx", false); } else if (IsAdmin) { Response.Redirect("ClerksPage.aspx", false); } else { Response.Redirect("PatientEntry.aspx", false); } } else { this.ErrorMessage += "Invalid Username or Password"; } } } catch (Exception ex) { this.ErrorMessage = "Exception " + ex; } }
protected override void OnLoad(System.EventArgs e) { base.OnLoad(e); if (this.UserId > 0) { int pid = 0; if (this.IsDoctor && Request.QueryString["id"] != null) { pid = Convert.ToInt32(Request.QueryString["id"]); } else { pid = this.UserId; } String sql = "SELECT id,firstname,lastname,firstname||' '||lastname as fullname FROM public.Login where id = " + pid; DataSet dsname = BaseDA.ExecuteDataSet(sql); if (dsname != null) { if (dsname.Tables.Count > 0) { DataTable dt = dsname.Tables[0]; foreach (DataRow dr in dt.Rows) { lblfullname.Text = dr["fullname"].ToString(); } } } string strSql = " SELECT *, bphigh || '/' || bplow as bp " + " FROM public.Patient where pid = " + pid + " order by entrydate desc"; DataSet ds = BaseDA.ExecuteDataSet(strSql); gvHist.DataSource = ds; gvHist.DataBind(); if (ds != null) { if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { gvHist.DataSource = ds.Tables[0]; gvHist.DataBind(); } else { gvHist.Visible = false; this.ErrorMessage += "No Resluts Found"; } } else { this.ErrorMessage += "DataSet is null"; } } else { this.ErrorMessage += "Please login to the System for further Access <br />"; Response.Redirect("Default.aspx"); } }
private DataTable getDoctorInfo() { string strSql = " SELECT id, firstname || ' ' || lastname as Name " + " FROM login where isdoctor = true " + " order by Name"; DataSet ds = BaseDA.ExecuteDataSet(strSql); gvHist.DataSource = ds; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null) { return(ds.Tables[0]); } return(null); }
private DataTable RefreshData() { string strSql = " select dr.*, l.*, l.lastname || ' ' || l.firstname as name" + " from doctorpatient dr " + " inner join login l on dr.patientid=l.id " + " where dr.doctorid = " + this.UserId; DataSet ds = BaseDA.ExecuteDataSet(strSql); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } return(null); }
protected void btnAssociate_Click(object sender, System.EventArgs e) { try { if (this.ValidateData()) { string strSql = " insert into doctorpatient(doctorid, patientid) " + " values ({0}, {1}); " + " update login set isnewuser=false where id={2} "; foreach (GridViewRow row in gvHist.Rows) { CheckBox chk = (CheckBox)(row.FindControl("chkSelect")); if (chk.Checked) { int PatId = Convert.ToInt32(row.Cells[1].Text); DropDownList ddlDoc = (DropDownList)(row.FindControl("ddlDoctor")); int intDocId = Convert.ToInt32(ddlDoc.SelectedValue); //check duplicate string userIdSql = string.Format("select * from doctorpatient where doctorid = " + intDocId + " and patientid = " + PatId); DataSet ds = BaseDA.ExecuteDataSet(userIdSql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; if (dr != null) { if (dr["doctorid"] != null) { ErrorMessage += "Patient " + row.Cells[2].Text + " already associated to the selected Doctor <br/>"; } } } else { BaseDA.ExecuteNonQuery(string.Format(strSql, intDocId, PatId, PatId)); } } } this.RefreshData(); } } catch (Exception ex) { this.ErrorMessage = "Exception : " + ex.Message; } }
protected void btnSubmit_Click(object sender, EventArgs e) { ErrorMessage = string.Empty; try { StrErros = string.Empty; if (string.IsNullOrEmpty(username)) { ErrorMessage += "You donot have access to this page"; Response.Redirect("Default.aspx"); } if (string.IsNullOrEmpty(txtPassword.Text.Trim())) { StrErros += "Password is required <br/>"; } if (string.IsNullOrEmpty(txtRetypePassword.Text.Trim())) { StrErros += "Retype Password is required <br/>"; } if (!string.IsNullOrEmpty(txtPassword.Text.Trim()) && !string.IsNullOrEmpty(txtRetypePassword.Text.Trim())) { if (txtPassword.Text.Trim() != txtRetypePassword.Text.Trim()) { StrErros += "Password and Retyped Password must be the same <br/>"; } } if (string.IsNullOrEmpty(StrErros)) { //update new password string strSql = string.Format("Update login set password='******' where " + "username = '******'", BaseDA.Escape(txtPassword.Text.Trim()), username); BaseDA.ExecuteNonQuery(strSql); Response.Redirect("PasswordChanged.aspx"); } } catch (Exception ex) { StrErros = "Exception " + ex; } }
protected void btnSubmit_Click(object sender, EventArgs e) { ErrorMessage = string.Empty; lblErrors.Text = string.Empty; try { //check for required field validation if (string.IsNullOrEmpty(txtUserId.Text.Trim())) { ErrorMessage += "User name is required <br/>"; } /* if (Int16.Parse(listSecQuestion.SelectedValue.Trim())== -1) * { * ErrorMessage += "Security question is required <br/>"; * }*/ if (string.IsNullOrEmpty(txtAnswer.Text.Trim())) { ErrorMessage += "Answer is required <br/>"; } if (string.IsNullOrEmpty(listMonth.SelectedValue.Trim()) || string.IsNullOrEmpty(txtDay.Text.Trim()) || string.IsNullOrEmpty(txtYear.Text.Trim())) { ErrorMessage += "Birthdate is required <br/>"; } DateTime birthDate = DateTime.MinValue; //Build birth date from the values entered and validate it if (!string.IsNullOrEmpty(listMonth.SelectedValue.Trim()) && !string.IsNullOrEmpty(txtDay.Text.Trim()) && !string.IsNullOrEmpty(txtYear.Text.Trim())) { double Num; bool isValidDay, isValidYear; isValidDay = double.TryParse(txtDay.Text, out Num); if (!isValidDay) { ErrorMessage = "Enter a valid date<br/>"; } isValidYear = double.TryParse(txtYear.Text, out Num); if (!isValidYear) { ErrorMessage = "Enter a valid date<br/>"; } if (!IsValidDate(listMonth.SelectedValue, txtDay.Text.Trim(), txtYear.Text.Trim())) { ErrorMessage = "Enter a valid date<br/>"; } } if (!string.IsNullOrEmpty(ErrorMessage)) { lblErrors.Text = ErrorMessage; } //Valid entry if (string.IsNullOrEmpty(ErrorMessage)) { int month = Int16.Parse(listMonth.SelectedValue); int day = Int16.Parse(txtDay.Text.Trim()); int year = Int16.Parse(txtYear.Text.Trim()); birthDate = new DateTime(year, month, day); string sql = string.Format( "SELECT * FROM LOGIN WHERE username= '******'and dob = '{1}' and securityQuestion= '{2}' and answer = '{3}'", BaseDA.Escape(txtUserId.Text.Trim()), birthDate, BaseDA.Escape(listSecQuestion.SelectedValue), BaseDA.Escape(txtAnswer.Text.Trim())); DataSet ds = BaseDA.ExecuteDataSet(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; if (dr != null) { Response.Redirect("ChangePassword.aspx?username="******"User does not exist. Please check if you have entered valid information </BR>"; } } } catch (Exception ex) { ErrorMessage = "Exception " + ex; lblErrors.Text = ErrorMessage; } }
protected void btnRegister_Click(object sender, EventArgs e) { ErrorMessage = string.Empty; lblErrors.Text = string.Empty; try { //check for required field validation if (string.IsNullOrEmpty(txtUserId.Text.Trim())) { ErrorMessage += "User name is required <br/>"; } //check if the user name selected already exists in the database, if it exists its an invalid entry if (!string.IsNullOrEmpty(txtUserId.Text.Trim())) { string userIdSql = string.Format("SELECT * FROM LOGIN WHERE username = '******'", BaseDA.Escape(txtUserId.Text.Trim())); DataSet ds = BaseDA.ExecuteDataSet(userIdSql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; if (dr != null) { if (dr["Id"] != null) { ErrorMessage += "User name already exists. Please choose a different user name <br/>"; } } } } if (string.IsNullOrEmpty(txtPassword.Text.Trim())) { ErrorMessage += "Password is required <br/>"; } if (string.IsNullOrEmpty(txtRetypePwd.Text.Trim())) { ErrorMessage += "Retype Password is required <br/>"; } // check that password = retyped password if (!string.IsNullOrEmpty(txtPassword.Text.Trim()) && !string.IsNullOrEmpty(txtRetypePwd.Text.Trim())) { if (txtPassword.Text.Trim() != txtRetypePwd.Text.Trim()) { ErrorMessage += "Password and Retyped Password must be the same <br/>"; } } if (string.IsNullOrEmpty(txtFirstName.Text.Trim())) { ErrorMessage += "First name is required <br/>"; } if (string.IsNullOrEmpty(txtLastName.Text.Trim())) { ErrorMessage += "Last name is required <br/>"; } /* if (Int16.Parse(listSecQuestion.SelectedValue.Trim())== -1) * { * ErrorMessage += "Security question is required <br/>"; * }*/ if (string.IsNullOrEmpty(txtAnswer.Text.Trim())) { ErrorMessage += "Answer is required <br/>"; } if (string.IsNullOrEmpty(listMonth.SelectedValue.Trim()) || string.IsNullOrEmpty(txtDay.Text.Trim()) || string.IsNullOrEmpty(txtYear.Text.Trim())) { ErrorMessage += "Birthdate is required <br/>"; } DateTime birthDate = DateTime.MinValue; //Build birth date from the values entered and validate it if (!string.IsNullOrEmpty(listMonth.SelectedValue.Trim()) && !string.IsNullOrEmpty(txtDay.Text.Trim()) && !string.IsNullOrEmpty(txtYear.Text.Trim())) { double Num; bool isValidDay, isValidYear; isValidDay = double.TryParse(txtDay.Text, out Num); if (!isValidDay) { ErrorMessage = "Enter a valid date<br/>"; } isValidYear = double.TryParse(txtYear.Text, out Num); if (!isValidYear) { ErrorMessage = "Enter a valid date<br/>"; } if (!IsValidDate(listMonth.SelectedValue, txtDay.Text.Trim(), txtYear.Text.Trim())) { ErrorMessage = "Enter a valid date<br/>"; } } if (!string.IsNullOrEmpty(ErrorMessage)) { lblErrors.Text = ErrorMessage; } //If there is no error message , Valid entry if (string.IsNullOrEmpty(ErrorMessage)) { int month = Int16.Parse(listMonth.SelectedValue); int day = Int16.Parse(txtDay.Text.Trim()); int year = Int16.Parse(txtYear.Text.Trim()); birthDate = new DateTime(year, month, day); //No validation errors, insert the entry string sql = string.Format("INSERT INTO LOGIN (username ,password,firstname,lastname,gender,dob,address,securityQuestion,answer,isnewuser) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", BaseDA.Escape(txtUserId.Text), BaseDA.Escape(txtPassword.Text), BaseDA.Escape(txtFirstName.Text), BaseDA.Escape(txtLastName.Text), BaseDA.Escape(listGender.SelectedValue), birthDate, BaseDA.Escape(txtAddress.Text), BaseDA.Escape(listSecQuestion.SelectedValue), BaseDA.Escape(txtAnswer.Text), "TRUE"); BaseDA.ExecuteNonQuery(sql); Response.Redirect("Default.aspx", true); } } catch (Exception ex) { ErrorMessage = "Exception " + ex; lblErrors.Text = ErrorMessage; } }
protected override void OnPreRender(System.EventArgs e) { base.OnPreRender(e); btnHelp.Attributes.Add("onclick", "window.open('PatientEntryhelp.aspx',null,'left=400, top=100, height=250, width= 400, status=no, resizable= no, scrollbars= yes, toolbar= no,location= no, menubar= no');"); lnkTip.Attributes.Add("onclick", "window.open('HealthTips.aspx',null,'left=400, top=100, height=250, width= 400, status=no, resizable= no, scrollbars= yes, toolbar= no,location= no, menubar= no');"); //ErrorMessage = string.Empty; //Clerks logs in if (IsAdmin == true) { lblpatient.Text = "Patient"; lblstar.Text = "*"; lblpatient.Visible = true; lblstar.Visible = true; lnkHist.Visible = false; lnkTip.Visible = false; listpid.Visible = true; if (this.UserId > 0) { //Fetch all the Patients' list String sql = "SELECT id,firstname,lastname,firstname||' '||lastname as fullname FROM public.Login where isadmin = false and isdoctor = false"; DataSet ds = BaseDA.ExecuteDataSet(sql); if (ds != null) { if (ds.Tables.Count > 0) { listpid.DataSource = ds; listpid.DataTextField = "fullname"; listpid.DataValueField = "fullname"; listpid.DataBind(); } else { this.ErrorMessage += "No Patient Entry Maintained <br />"; } } else { this.ErrorMessage += "DataSet is null"; } } else { this.ErrorMessage += "Please login to the System for further Access <br />"; Response.Redirect("Default.aspx"); } String sqlid = "SELECT id FROM public.Login where isadmin = false and isdoctor = false and firstname||' '||lastname = '" + listpid.SelectedItem.Value + "'"; DataSet dspatid = BaseDA.ExecuteDataSet(sqlid); if (dspatid != null) { if (dspatid.Tables.Count > 0) { DataTable dt = dspatid.Tables[0]; foreach (DataRow dr in dt.Rows) { lblpatid.Text = dr["id"].ToString(); } } } } //Patient logs in if ((IsAdmin == false) && (IsDoctor == false)) { lblpatid.Text = this.UserId.ToString(); listpid.Visible = false; lblpatient.Visible = false; lblstar.Visible = false; lnkHist.Visible = true; lnkTip.Visible = true; } }
protected void btnpatient_Click(object sender, EventArgs e) { try { /*StringBuilder sb = new StringBuilder(); * sb.Append("<script language=\"javascript\">" + "\n"); * sb.Append("function confirmthis() { if(confirm(”Do you want to do save this record?”)) { return true; } else { return false; } }"); * sb.Append("</script>"); * Page.ClientScript.RegisterStartupScript( * this.Page.GetType(), * "OpenPopup", * sb.ToString());*/ ErrorMessage = string.Empty; //clerk if (IsAdmin == true) { //populate list box with patient names String sql1 = "SELECT id FROM public.Login where isadmin = false and isdoctor = false and firstname||' '||lastname = '" + listpid.SelectedValue + "'"; DataSet ds = BaseDA.ExecuteDataSet(sql1); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; if (dr != null) { if (dr["Id"] != null) { lblpatid.Text = dr["id"].ToString(); } } } } //patient //store the patient id to be inserted later for new records if (IsAdmin == false) { lblpatid.Text = this.UserId.ToString(); } //Field Validations if (string.IsNullOrEmpty(listpid.Text.Trim())) { this.ErrorMessage += "No Patient Selected <br />"; } if ((string.IsNullOrEmpty(txttemp.Text.Trim()))) { ErrorMessage += "Temperature Is Required. <br />"; } else { if (!CheckIfNumbericTemp(txttemp.Text)) { this.ErrorMessage += "Temperature should be a Numeric Value<br />"; } else { if ((Convert.ToDouble(txttemp.Text) <= 80.00) || (Convert.ToDouble(txttemp.Text) >= 120.00)) { this.ErrorMessage += "Temperature should be a positive number between 80 and 120, decimal numbers are accepted. <br />"; } } } if (string.IsNullOrEmpty(txtbphigh.Text.Trim())) { this.ErrorMessage += "Blood Pressure - HIGH Is Required. <br />"; } else { if (!CheckIfNumberic(txtbphigh.Text)) { this.ErrorMessage += "Blood Pressure - HIGH should be Numeric Value<br />"; } else { if ((txtbphigh.Text.Length) > 5) { this.ErrorMessage += "Invalid Blood Pressure - HIGH value.Digits Cannot be Greater than 5 <br />"; } else { if (((Convert.ToInt32(txtbphigh.Text) <= 0))) { this.ErrorMessage += "Blood Pressure - HIGH value must be positive number, decimal numbers are not accepted. <br />"; } } } } if (string.IsNullOrEmpty(txtbplow.Text.Trim())) { this.ErrorMessage += "Blood Pressure - LOW Is Required. <br />"; } else { if (!CheckIfNumberic(txtbplow.Text)) { this.ErrorMessage += "Blood Pressure - LOW should be Numeric Value<br />"; } else { if ((txtbplow.Text.Length) > 5) { this.ErrorMessage += "Invalid Blood Pressure - LOW value.Digits Cannot be Greater than 5 <br />"; } else { if (((Convert.ToInt32(txtbplow.Text) <= 0))) { this.ErrorMessage += "Blood Pressure - LOW value must be positive number, decimal numbers are not accepted. <br />"; } } } if ((Convert.ToInt32(txtbplow.Text)) > (Convert.ToInt32(txtbphigh.Text))) { this.ErrorMessage += "Blood Pressure - LOW value must be Less Than Blood Pressure - HIGH. <br/>"; } } if (string.IsNullOrEmpty(txtpulserate.Text.Trim())) { this.ErrorMessage += "Pulse Rate Is Required. <br />"; } else { if (!CheckIfNumberic(txtpulserate.Text)) { this.ErrorMessage += "Pulse Rate should be a Numeric Value<br />"; } else { if (((Convert.ToInt32(txtpulserate.Text) <= 20)) || ((Convert.ToInt32(txtpulserate.Text) >= 200))) { this.ErrorMessage += "Pulse Rate must be a positive number between 20 and 200, decimal numbers are not accepted. <br />"; } } } if (string.IsNullOrEmpty(txtglucose.Text.Trim())) { } else { if (!CheckIfNumberic(txtglucose.Text)) { this.ErrorMessage += "Glucose should be a Numeric Value <br />"; } else { if ((Convert.ToInt32(txtglucose.Text) <= 20) || (Convert.ToInt32(txtglucose.Text) >= 300)) { this.ErrorMessage += "Glucose level must be a positive number between 20 and 300. Decimal numbers are not accepted. <br />"; } } } String sql; int dbinsert = 0; bool isConfirmNeeded = false; string confirmMessage = string.Empty; // All server side execution goes here and, if user confirmation is needed, // set isConfirmNeeded to true and create the confirmMessage text. //Insert Records if (string.IsNullOrEmpty(ErrorMessage)) { //glucose is blank, pain and desc are not blank if ((string.IsNullOrEmpty(txtglucose.Text.Trim())) && (listpainlevel.SelectedValue != "Select") && (!string.IsNullOrEmpty(txtdescription.Text.Trim()))) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + "NULL" + "," + listpainlevel.Text + ",'" + txtdescription.Text + "',CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } //pain and glucose is blank,desc is not blank if ((string.IsNullOrEmpty(txtglucose.Text.Trim())) && (listpainlevel.SelectedValue.Trim().Contains("Select")) && (!string.IsNullOrEmpty(txtdescription.Text.Trim()))) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + "NULL" + "," + "NULL" + ",'" + txtdescription.Text + "',CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } //desc and glucose is blank,pain is not blank if ((string.IsNullOrEmpty(txtglucose.Text.Trim())) && (listpainlevel.SelectedValue != "Select") && (string.IsNullOrEmpty(txtdescription.Text.Trim()))) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + "NULL" + "," + listpainlevel.Text + "," + "NULL" + ",CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } //pain and desc is blank, glucose is not blank if ((!string.IsNullOrEmpty(txtglucose.Text.Trim())) && (listpainlevel.SelectedValue.Trim().Contains("Select")) && (string.IsNullOrEmpty(txtdescription.Text.Trim()))) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + txtglucose.Text + "," + "NULL" + "," + "NULL" + ",CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } //pain is blank, glucose and desc are not blank if ((listpainlevel.SelectedValue.Trim().Contains("Select")) && (!string.IsNullOrEmpty(txtglucose.Text.Trim())) && (!string.IsNullOrEmpty(txtdescription.Text.Trim()))) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + txtglucose.Text + "," + "NULL" + ",'" + txtdescription.Text + "',CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } //desc is blank, glucose and pain is not blank if ((string.IsNullOrEmpty(txtdescription.Text.Trim())) && (!string.IsNullOrEmpty(txtglucose.Text.Trim())) && (listpainlevel.SelectedValue != "Select")) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + txtglucose.Text + "," + listpainlevel.Text + "," + "NULL" + ",CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } //all blank if ((string.IsNullOrEmpty(txtdescription.Text.Trim())) && (string.IsNullOrEmpty(txtglucose.Text.Trim())) && (listpainlevel.SelectedValue.Trim().Contains("Select"))) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + "NULL" + "," + "NULL" + "," + "NULL" + ",CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } //all filled if (!string.IsNullOrEmpty(txtdescription.Text.Trim()) && (!string.IsNullOrEmpty(txtglucose.Text.Trim())) && (listpainlevel.SelectedValue != "Select")) { sql = string.Format("INSERT into public.patient (pid,temperature,bphigh,bplow,glucose,painlevel,description,entrydate,pulserate) VALUES (" + lblpatid.Text + "," + txttemp.Text + "," + txtbphigh.Text + "," + txtbplow.Text + "," + txtglucose.Text + "," + listpainlevel.Text + ",'" + txtdescription.Text + "',CURRENT_DATE," + txtpulserate.Text + ")"); dbinsert = BaseDA.ExecuteNonQuery(sql); } if (dbinsert != -1) // Record Inserted Successfuly { StringBuilder sb = new StringBuilder(); sb.Append("<script language=\"javascript\">" + "\n"); sb.Append("alert(\"Record Inserted Successfuly\")"); sb.Append("</script>"); Page.ClientScript.RegisterStartupScript( this.Page.GetType(), "OpenPopup", sb.ToString()); } else //Failed to Insert the Record" { StringBuilder sb = new StringBuilder(); sb.Append("<script language=\"javascript\">" + "\n"); sb.Append("alert(\"Failed to Insert the Record\")"); sb.Append("</script>"); Page.ClientScript.RegisterStartupScript( this.Page.GetType(), "OpenPopup", sb.ToString()); } } } catch (Exception ex) { lblErrors.Text = ErrorMessage; } }