예제 #1
0
 protected void Delete_Click(object sender, EventArgs e)
 {
     try
     {
         CheckBox        chk   = new CheckBox();
         Label           lbl   = new Label();
         string          patid = "";
         PatientDataTier std   = new PatientDataTier();
         if (grdStudents.Rows.Count > 0)
         {
             foreach (GridViewRow row in grdStudents.Rows)
             {
                 chk = (CheckBox)row.FindControl("chkPatID");
                 if (chk.Checked)
                 {
                     lbl   = (Label)row.Controls[0].FindControl("hidPatID");
                     patid = lbl.Text.Trim();
                     std.DeletePatient(patid);
                 }
             }
             DataBind();
         }
     }
     catch
     {
     }
 }
예제 #2
0
        protected void btnHidden_Click(object sender, EventArgs e)
        {
            try
            {
                string reply;
                // Adds into SQL database
                try
                {
                    PatientDataTier.AddPatient(txtFName.Text, txtMidInit.Text, txtLName.Text, ddlGender.Text, txtStreet.Text,
                                               txtCity.Text, ddlState.Text, decimal.Parse(txtZIP.Text), DateTime.Parse(txtDOB.Text), txtHomePhone.Text,
                                               txtCellPhone.Text, txtEmailI.Text);

                    reply           = "Success";
                    lblDisplay.Text = reply;
                }
                catch (Exception Ex)
                {
                    throw new Exception(Ex.Message);
                }
                finally
                {
                }
            }
            catch (Exception Ex)
            {
            }
            finally
            {
            }
        }
예제 #3
0
        private void DataBind()
        {
            PatientDataTier aDatatier = new PatientDataTier();

            DataSet aDataSet = new DataSet();

            aDataSet = aDatatier.ViewPatient("", "", "");

            grdStudents.DataSource = aDataSet.Tables[0];

            // Cache for a while
            if (Cache["CustomerData"] != null)
            {
                Cache.Add("StudentData", new DataView(aDataSet.Tables[0]),
                          null, System.Web.Caching.Cache.NoAbsoluteExpiration, System.TimeSpan.FromMinutes(10),
                          System.Web.Caching.CacheItemPriority.Default, null);
            }
            grdStudents.DataBind();
        }
예제 #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                PatientDataTier dataTier = new PatientDataTier();
                if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
                {
                    DataSet dataSet = new DataSet();
                    string  patid   = Request.QueryString["ID"];
                    dataSet = dataTier.FindByID(patid);
                    if (Request.QueryString["ID"].Trim().ToUpper() == "EDIT")
                    {
                    }
                    else
                    {
                        //Response.Redirect("~/ViewPatients.aspx");
                        lblPatientID.Text = dataSet.Tables[0].Rows[0]["patient_id"].ToString();
                        txtFName.Text     = dataSet.Tables[0].Rows[0]["fname"].ToString();
                        txtMidInit.Text   = dataSet.Tables[0].Rows[0]["midint"].ToString();
                        txtLName.Text     = dataSet.Tables[0].Rows[0]["lname"].ToString();
                        ddlGender.Text    = dataSet.Tables[0].Rows[0]["gender"].ToString();
                        txtDOB.Text       = dataSet.Tables[0].Rows[0]["dob"].ToString();
                        txtStreet.Text    = dataSet.Tables[0].Rows[0]["streetname"].ToString();
                        txtCity.Text      = dataSet.Tables[0].Rows[0]["city"].ToString();
                        ddlState.Text     = dataSet.Tables[0].Rows[0]["pait_state"].ToString();

                        ddlState.DataSource     = StateManager.getStates();
                        ddlState.DataTextField  = "FullAndAbbrev";
                        ddlState.DataValueField = "abbreviation";
                        ddlState.SelectedValue  = "PA";
                        ddlState.DataBind();

                        txtZIP.Text       = dataSet.Tables[0].Rows[0]["zip"].ToString();
                        txtHomePhone.Text = dataSet.Tables[0].Rows[0]["home_phone"].ToString();
                        txtCellPhone.Text = dataSet.Tables[0].Rows[0]["cell_phone"].ToString();
                        txtEmailI.Text    = dataSet.Tables[0].Rows[0]["email"].ToString();
                    }
                }
            }
        }
예제 #5
0
        private void DataBind()
        {
            PatientDataTier aDatatier = new PatientDataTier();

            ViewState["vpatid"] = txtPatientID.Text.Trim();


            DataSet aDataSet = new DataSet();

            aDataSet = aDatatier.GetPatient(Convert.ToString(ViewState["vpatid"]));

            grdPatient.DataSource = aDataSet.Tables[0];

            // Cache for a while
            if (Cache["PatientData"] == null)
            {
                Cache.Add("PatientData", new DataView(aDataSet.Tables[0]),
                          null, System.Web.Caching.Cache.NoAbsoluteExpiration, System.TimeSpan.FromMinutes(10),
                          System.Web.Caching.CacheItemPriority.Default, null);
            }
            grdPatient.DataBind();
        }