コード例 #1
0
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            using (AffiliationTempDBContext db = new AffiliationTempDBContext())
            {
                AffiliationsTemp updateAff = new AffiliationsTemp();
                int ID = int.Parse(txtAffID.Text);
                //Affiliation updateAff = (from Aff_tbl in db.Affiliations where Aff_tbl.Deleted == null && Aff_tbl.AffiliationID == ID select Aff_tbl).FirstOrDefault();
                updateAff.AffiliationID   = ID;
                updateAff.AffiliationName = txtAffiliationName.Text;
                updateAff.PhysicianID     = int.Parse(txtAffPhyCode.Text);
                updateAff.EntityID        = int.Parse(txtAffClinicCode.Text);
                updateAff.BestTimeFrom    = txtBestTimeFrom.Text;
                updateAff.BestTimeTo      = txtBestTimeTo.Text;
                updateAff.Notes           = txtNotes.Text;
                updateAff.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString());
                updateAff.Deleted         = false;
                updateAff.EntryDate       = DateTime.Now;
                updateAff.Status          = false;
                updateAff.New             = false;

                db.AffiliationsTemps.Add(updateAff);
                int roweffected = db.SaveChanges();

                affiliationslblSaveStatus.Text = "Updated";
            }

            using (PhysiciansValueTempDBContext db = new PhysiciansValueTempDBContext())
            {
                int ID = int.Parse(txtAffID.Text);

                for (int i = 1; i <= 7; i++)
                {
                    if (i == 1)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine1.SelectedValue), double.Parse(ddlNoPatients1.SelectedValue), int.Parse(txtRecID1.Text), false, double.Parse(ddlWT1.SelectedValue));
                    }
                    if (i == 2)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine2.SelectedValue), double.Parse(ddlNoPatients2.SelectedValue), int.Parse(txtRecID2.Text), false, double.Parse(ddlWT2.SelectedValue));
                    }
                    if (i == 3)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine3.SelectedValue), double.Parse(ddlNoPatients3.SelectedValue), int.Parse(txtRecID3.Text), false, double.Parse(ddlWT3.SelectedValue));
                    }
                    if (i == 4)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine4.SelectedValue), double.Parse(ddlNoPatients4.SelectedValue), int.Parse(txtRecID4.Text), false, double.Parse(ddlWT4.SelectedValue));
                    }
                    if (i == 5)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine5.SelectedValue), double.Parse(ddlNoPatients5.SelectedValue), int.Parse(txtRecID5.Text), false, double.Parse(ddlWT5.SelectedValue));
                    }
                    if (i == 6)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine6.SelectedValue), double.Parse(ddlNoPatients6.SelectedValue), int.Parse(txtRecID6.Text), false, double.Parse(ddlWT6.SelectedValue));
                    }
                    if (i == 7)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine7.SelectedValue), double.Parse(ddlNoPatients7.SelectedValue), int.Parse(txtRecID7.Text), false, double.Parse(ddlWT7.SelectedValue));
                    }
                }
            }

            txtAffID.Text                = "";
            txtAffiliationName.Text      = "";
            txtBestTimeFrom.Text         = "";
            txtBestTimeTo.Text           = "";
            txtNotes.Text                = "";
            txtAffClinicCode.Text        = "";
            txtAffPhyCode.Text           = "";
            txtSpCode.Text               = "";
            ddlNoPatients1.SelectedIndex = 0;
            ddlNoPatients2.SelectedIndex = 0;
            ddlNoPatients3.SelectedIndex = 0;
            ddlNoPatients4.SelectedIndex = 0;
            ddlNoPatients5.SelectedIndex = 0;
            ddlNoPatients6.SelectedIndex = 0;
            ddlNoPatients7.SelectedIndex = 0;
            ddlLine1.SelectedIndex       = 0;
            ddlLine2.SelectedIndex       = 0;
            ddlLine3.SelectedIndex       = 0;
            ddlLine4.SelectedIndex       = 0;
            ddlLine5.SelectedIndex       = 0;
            ddlLine6.SelectedIndex       = 0;
            ddlLine7.SelectedIndex       = 0;
            ddlWT1.SelectedIndex         = 0;
            ddlWT2.SelectedIndex         = 0;
            ddlWT3.SelectedIndex         = 0;
            ddlWT4.SelectedIndex         = 0;
            ddlWT5.SelectedIndex         = 0;
            ddlWT6.SelectedIndex         = 0;
            ddlWT7.SelectedIndex         = 0;

            btnUpdate.Visible = false;
            btnSave.Visible   = true;
        }
コード例 #2
0
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            using (AffiliationTempDBContext db = new AffiliationTempDBContext())
            {
                AffiliationsTemp updateAff = new AffiliationsTemp();
                int ID = int.Parse(txtAffID.Text);
                //Affiliation updateAff = (from Aff_tbl in db.Affiliations where Aff_tbl.Deleted == null && Aff_tbl.AffiliationID == ID select Aff_tbl).FirstOrDefault();
                updateAff.AffiliationID   = ID;
                updateAff.AffiliationName = txtAffiliationName.Text;
                updateAff.PhysicianID     = int.Parse(txtAffPhyCode.Text);
                updateAff.EntityID        = int.Parse(txtAffClinicCode.Text);
                updateAff.BestTimeFrom    = txtBestTimeFrom.Text;
                updateAff.BestTimeTo      = txtBestTimeTo.Text;
                updateAff.Notes           = txtNotes.Text;
                updateAff.Deleted         = true;
                updateAff.EntryDate       = DateTime.Now;
                updateAff.Status          = false;
                updateAff.New             = false;
                updateAff.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString());
                db.AffiliationsTemps.Add(updateAff);
                int roweffected = db.SaveChanges();

                affiliationslblSaveStatus.Text = "deleted";
            }

            using (PhysiciansValueTempDBContext db = new PhysiciansValueTempDBContext())
            {
                int ID = int.Parse(txtAffID.Text);

                for (int i = 1; i <= 7; i++)
                {
                    if (i == 1)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine1.SelectedValue), double.Parse(ddlNoPatients1.SelectedValue), int.Parse(txtRecID1.Text), true, double.Parse(ddlWT1.SelectedValue));
                    }
                    if (i == 2)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine2.SelectedValue), double.Parse(ddlNoPatients2.SelectedValue), int.Parse(txtRecID2.Text), true, double.Parse(ddlWT2.SelectedValue));
                    }
                    if (i == 3)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine3.SelectedValue), double.Parse(ddlNoPatients3.SelectedValue), int.Parse(txtRecID3.Text), true, double.Parse(ddlWT3.SelectedValue));
                    }
                    if (i == 4)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine4.SelectedValue), double.Parse(ddlNoPatients4.SelectedValue), int.Parse(txtRecID4.Text), true, double.Parse(ddlWT4.SelectedValue));
                    }
                    if (i == 5)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine5.SelectedValue), double.Parse(ddlNoPatients5.SelectedValue), int.Parse(txtRecID5.Text), true, double.Parse(ddlWT5.SelectedValue));
                    }
                    if (i == 6)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine6.SelectedValue), double.Parse(ddlNoPatients6.SelectedValue), int.Parse(txtRecID6.Text), true, double.Parse(ddlWT6.SelectedValue));
                    }
                    if (i == 7)
                    {
                        PhValueUpdate(db, ID, i, double.Parse(ddlLine7.SelectedValue), double.Parse(ddlNoPatients7.SelectedValue), int.Parse(txtRecID7.Text), true, double.Parse(ddlWT7.SelectedValue));
                    }
                }
            }

            txtAffID.Text                = "";
            txtAffiliationName.Text      = "";
            txtBestTimeFrom.Text         = "";
            txtBestTimeTo.Text           = "";
            txtNotes.Text                = "";
            txtAffClinicCode.Text        = "";
            txtAffPhyCode.Text           = "";
            txtSpCode.Text               = "";
            ddlNoPatients1.SelectedIndex = 0;
            ddlNoPatients2.SelectedIndex = 0;
            ddlNoPatients3.SelectedIndex = 0;
            ddlNoPatients4.SelectedIndex = 0;
            ddlNoPatients5.SelectedIndex = 0;
            ddlNoPatients6.SelectedIndex = 0;
            ddlNoPatients7.SelectedIndex = 0;
            ddlLine1.SelectedIndex       = 0;
            ddlLine2.SelectedIndex       = 0;
            ddlLine3.SelectedIndex       = 0;
            ddlLine4.SelectedIndex       = 0;
            ddlLine5.SelectedIndex       = 0;
            ddlLine6.SelectedIndex       = 0;
            ddlLine7.SelectedIndex       = 0;
            ddlWT1.SelectedIndex         = 0;
            ddlWT2.SelectedIndex         = 0;
            ddlWT3.SelectedIndex         = 0;
            ddlWT4.SelectedIndex         = 0;
            ddlWT5.SelectedIndex         = 0;
            ddlWT6.SelectedIndex         = 0;
            ddlWT7.SelectedIndex         = 0;

            btnUpdate.Visible = false;
            btnSave.Visible   = true;
            affiliationslblSaveStatus.Text = "Deleted";

            //int ID = int.Parse(txtAffID.Text);

            //conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AmounCrmConnectionString"].ToString());
            //conn.Open();
            //cmd = new SqlCommand("update Affiliations set Deleted=1 where AffiliationID=" + ID, conn);
            //int Affrows = cmd.ExecuteNonQuery();
            //cmd = new SqlCommand("update PhysicianValueByLine set Deleted=1 where AffiliationID=" + ID, conn);
            //int PhValrows = cmd.ExecuteNonQuery();
            //conn.Close();



            //txtAffID.Text = "";
            //txtAffiliationName.Text = "";
            //txtBestTimeFrom.Text = "";
            //txtBestTimeTo.Text = "";
            //txtNotes.Text = "";
            //txtAffClinicCode.Text = "";
            //txtAffPhyCode.Text = "";
            //txtSpCode.Text = "";
            //ddlNoPatients1.SelectedIndex = 0;
            //ddlNoPatients2.SelectedIndex = 0;
            //ddlNoPatients3.SelectedIndex = 0;
            //ddlNoPatients4.SelectedIndex = 0;
            //ddlNoPatients5.SelectedIndex = 0;
            //ddlNoPatients6.SelectedIndex = 0;
            //ddlNoPatients7.SelectedIndex = 0;
            //ddlLine1.SelectedIndex = 0;
            //ddlLine2.SelectedIndex = 0;
            //ddlLine3.SelectedIndex = 0;
            //ddlLine4.SelectedIndex = 0;
            //ddlLine5.SelectedIndex = 0;
            //ddlLine6.SelectedIndex = 0;
            //ddlLine7.SelectedIndex = 0;
            //btnUpdate.Visible = false;
            //btnSave.Visible = true;
            //btnDelete.Visible = false;
            //affiliationslblSaveStatus.Text = "Deleted";
        }
コード例 #3
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            using (AffiliationTempDBContext newAff = new AffiliationTempDBContext())
            {
                AffiliationsTemp Aff = new AffiliationsTemp();

                using (PhysicianBDContext PHdb = new PhysicianBDContext())
                {
                    int PhyCode       = int.Parse(txtAffPhyCode.Text);
                    var PhysicianData = (from physicion_tbl in PHdb.Physicians where physicion_tbl.PhysicianID == PhyCode select physicion_tbl).FirstOrDefault();
                    txtAffiliationName.Text = PhysicianData.PhysicianName;
                    txtSpCode.Text          = (PhysicianData.SpecialtyID).ToString();
                }

                Aff.AffiliationName = txtAffiliationName.Text;
                Aff.PhysicianID     = int.Parse(txtAffPhyCode.Text);
                Aff.EntityID        = int.Parse(txtAffClinicCode.Text);
                Aff.BestTimeFrom    = txtBestTimeFrom.Text;
                Aff.BestTimeTo      = txtBestTimeTo.Text;
                Aff.Notes           = txtNotes.Text;
                Aff.New             = true;
                Aff.Status          = false;
                Aff.Deleted         = false;
                Aff.EntryEmployeeID = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString());
                Aff.EntryDate       = DateTime.Now;

                newAff.AffiliationsTemps.Add(Aff);
                int roweffected = newAff.SaveChanges();
                if (roweffected > 0)
                {
                    affiliationslblSaveStatus.Text = "Saved";
                    using (AffiliationTempDBContext db = new AffiliationTempDBContext())
                    {
                        int maxent = db.AffiliationsTemps.Max(en => en.ID);
                        txtAffID.Text = maxent.ToString();
                    }
                }
                else
                {
                    affiliationslblSaveStatus.Text = "Error";
                }
            }
            using (PhysiciansValueTempDBContext newPhVal = new PhysiciansValueTempDBContext())
            {
                int spcode = int.Parse(txtSpCode.Text);
                PhysicianValueByLineTemp PhyVal = new PhysicianValueByLineTemp();

                for (int i = 1; i <= 7; i++)
                {
                    PhyVal.AffiliationID = int.Parse(txtAffID.Text);
                    PhyVal.LineID        = i;

                    if (i == 1)
                    {
                        PhyVal.PrescriptionHappit = Double.Parse(ddlLine1.SelectedValue);
                        PhyVal.NoOfPatients       = Double.Parse(ddlNoPatients1.SelectedValue);
                        PhyVal.WaitingTime        = Double.Parse(ddlWT1.SelectedValue);
                    }
                    if (i == 2)
                    {
                        PhyVal.PrescriptionHappit = Double.Parse(ddlLine2.SelectedValue);
                        PhyVal.NoOfPatients       = Double.Parse(ddlNoPatients2.SelectedValue);
                        PhyVal.WaitingTime        = Double.Parse(ddlWT2.SelectedValue);
                    }
                    if (i == 3)
                    {
                        PhyVal.PrescriptionHappit = Double.Parse(ddlLine3.SelectedValue);
                        PhyVal.NoOfPatients       = Double.Parse(ddlNoPatients3.SelectedValue);
                        PhyVal.WaitingTime        = Double.Parse(ddlWT3.SelectedValue);
                    }
                    if (i == 4)
                    {
                        PhyVal.PrescriptionHappit = Double.Parse(ddlLine4.SelectedValue);
                        PhyVal.NoOfPatients       = Double.Parse(ddlNoPatients4.SelectedValue);
                        PhyVal.WaitingTime        = Double.Parse(ddlWT4.SelectedValue);
                    }
                    if (i == 5)
                    {
                        PhyVal.PrescriptionHappit = Double.Parse(ddlLine5.SelectedValue);
                        PhyVal.NoOfPatients       = Double.Parse(ddlNoPatients5.SelectedValue);
                        PhyVal.WaitingTime        = Double.Parse(ddlWT5.SelectedValue);
                    }
                    if (i == 6)
                    {
                        PhyVal.PrescriptionHappit = Double.Parse(ddlLine6.SelectedValue);
                        PhyVal.NoOfPatients       = Double.Parse(ddlNoPatients6.SelectedValue);
                        PhyVal.WaitingTime        = Double.Parse(ddlWT6.SelectedValue);
                    }
                    if (i == 7)
                    {
                        PhyVal.PrescriptionHappit = Double.Parse(ddlLine7.SelectedValue);
                        PhyVal.NoOfPatients       = Double.Parse(ddlNoPatients7.SelectedValue);
                        PhyVal.WaitingTime        = Double.Parse(ddlWT7.SelectedValue);
                    }
                    using (SpecialtyPriorityDBContext SVdb = new SpecialtyPriorityDBContext())
                    {
                        var SVData = (from SV_tbl in SVdb.SpecPriorityByLines where SV_tbl.LineID == i && SV_tbl.SpecialtyID == spcode select SV_tbl).FirstOrDefault();
                        PhyVal.SpecialtyValue = SVData.SpecValue / 10;
                    }
                    PhyVal.TotalValue = PhyVal.SpecialtyValue + PhyVal.PrescriptionHappit + PhyVal.NoOfPatients;

                    if (PhyVal.TotalValue >= 8)
                    {
                        PhyVal.PhysicianClass = "A+";
                    }
                    if (PhyVal.TotalValue < 8)
                    {
                        if (PhyVal.TotalValue >= 4.5)
                        {
                            PhyVal.PhysicianClass = "A";
                        }
                        if (PhyVal.TotalValue < 4.5)
                        {
                            PhyVal.PhysicianClass = "C";
                        }
                    }
                    PhyVal.LastModifierID       = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString());
                    PhyVal.CreateDate           = DateTime.Now;
                    PhyVal.CreatorID            = int.Parse(Session["EmployeeHRCodeFromAdmin"].ToString());
                    PhyVal.LastModificationDate = DateTime.Now;
                    PhyVal.New     = true;
                    PhyVal.Deleted = false;
                    PhyVal.Status  = false;
                    newPhVal.PhysicianValueByLineTemps.Add(PhyVal);
                    int roweffected = newPhVal.SaveChanges();
                    if (roweffected > 0)
                    {
                        affiliationslblSaveStatus.Text = "Saved";
                    }
                    else
                    {
                        affiliationslblSaveStatus.Text = "Error";
                    }
                }
            }
        }