C# (CSharp) Common_GetDoctorAppointmentsByIdBL Exemples

Exemple #1

Fichier : ReceptionistViewCalendarAppointments.aspx.cs Projet : devangsinha/Hospital-Management-System

 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
 {
     int doctorId = Convert.ToInt32(DropDownList1.SelectedValue);
     Common_GetDoctorAppointmentsByIdBL objCommon_GetDoctorAppointmentsByIdBL = new Common_GetDoctorAppointmentsByIdBL();
     GridView1.DataSource = objCommon_GetDoctorAppointmentsByIdBL.Common_GetDoctorAppointmentsById(doctorId);
     GridView1.DataBind();
 }

Exemple #2

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        int doctorId = Convert.ToInt32(DropDownList1.SelectedValue);
        Common_GetDoctorAppointmentsByIdBL objCommon_GetDoctorAppointmentsByIdBL = new Common_GetDoctorAppointmentsByIdBL();

        GridView1.DataSource = objCommon_GetDoctorAppointmentsByIdBL.Common_GetDoctorAppointmentsById(doctorId);
        GridView1.DataBind();
    }

Exemple #3

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int empId = Convert.ToInt32(Session["doctorId"].ToString());

            Common_GetEmployeeScheduleBL objGetEmployeeScheduleBL = new Common_GetEmployeeScheduleBL();
            DataSet ds = new DataSet();
            ds           = objGetEmployeeScheduleBL.Common_GetEmployeeSchedule(empId);
            Label1.Text  = ds.Tables[0].Rows[0]["MON_SESS1_FROM"].ToString();
            Label2.Text  = ds.Tables[0].Rows[0]["MON_SESS1_TO"].ToString();
            Label3.Text  = ds.Tables[0].Rows[0]["MON_SESS2_FROM"].ToString();
            Label4.Text  = ds.Tables[0].Rows[0]["MON_SESS2_TO"].ToString();
            Label5.Text  = ds.Tables[0].Rows[0]["MON_SESS3_FROM"].ToString();
            Label6.Text  = ds.Tables[0].Rows[0]["MON_SESS3_TO"].ToString();
            Label7.Text  = ds.Tables[0].Rows[0]["TUE_SESS1_FROM"].ToString();
            Label8.Text  = ds.Tables[0].Rows[0]["TUE_SESS1_TO"].ToString();
            Label9.Text  = ds.Tables[0].Rows[0]["TUE_SESS2_FROM"].ToString();
            Label10.Text = ds.Tables[0].Rows[0]["TUE_SESS2_TO"].ToString();
            Label11.Text = ds.Tables[0].Rows[0]["TUE_SESS3_FROM"].ToString();
            Label12.Text = ds.Tables[0].Rows[0]["TUE_SESS3_TO"].ToString();
            Label13.Text = ds.Tables[0].Rows[0]["WED_SESS1_FROM"].ToString();
            Label14.Text = ds.Tables[0].Rows[0]["WED_SESS1_TO"].ToString();
            Label15.Text = ds.Tables[0].Rows[0]["WED_SESS2_FROM"].ToString();
            Label16.Text = ds.Tables[0].Rows[0]["WED_SESS2_TO"].ToString();
            Label17.Text = ds.Tables[0].Rows[0]["WED_SESS3_FROM"].ToString();
            Label18.Text = ds.Tables[0].Rows[0]["WED_SESS3_TO"].ToString();
            Label19.Text = ds.Tables[0].Rows[0]["THU_SESS1_FROM"].ToString();
            Label20.Text = ds.Tables[0].Rows[0]["THU_SESS1_TO"].ToString();
            Label21.Text = ds.Tables[0].Rows[0]["THU_SESS2_FROM"].ToString();
            Label22.Text = ds.Tables[0].Rows[0]["THU_SESS2_TO"].ToString();
            Label23.Text = ds.Tables[0].Rows[0]["THU_SESS3_FROM"].ToString();
            Label24.Text = ds.Tables[0].Rows[0]["THU_SESS3_TO"].ToString();
            Label25.Text = ds.Tables[0].Rows[0]["FRI_SESS1_FROM"].ToString();
            Label26.Text = ds.Tables[0].Rows[0]["FRI_SESS1_TO"].ToString();
            Label27.Text = ds.Tables[0].Rows[0]["FRI_SESS2_FROM"].ToString();
            Label28.Text = ds.Tables[0].Rows[0]["FRI_SESS2_TO"].ToString();
            Label29.Text = ds.Tables[0].Rows[0]["FRI_SESS3_FROM"].ToString();
            Label30.Text = ds.Tables[0].Rows[0]["FRI_SESS3_TO"].ToString();
            Label31.Text = ds.Tables[0].Rows[0]["SAT_SESS1_FROM"].ToString();
            Label32.Text = ds.Tables[0].Rows[0]["SAT_SESS1_TO"].ToString();
            Label33.Text = ds.Tables[0].Rows[0]["SAT_SESS2_FROM"].ToString();
            Label34.Text = ds.Tables[0].Rows[0]["SAT_SESS2_TO"].ToString();
            Label35.Text = ds.Tables[0].Rows[0]["SAT_SESS3_FROM"].ToString();
            Label36.Text = ds.Tables[0].Rows[0]["SAT_SESS3_TO"].ToString();
            Label37.Text = ds.Tables[0].Rows[0]["SUN_SESS1_FROM"].ToString();
            Label38.Text = ds.Tables[0].Rows[0]["SUN_SESS1_TO"].ToString();
            Label39.Text = ds.Tables[0].Rows[0]["SUN_SESS2_FROM"].ToString();
            Label40.Text = ds.Tables[0].Rows[0]["SUN_SESS2_TO"].ToString();
            Label41.Text = ds.Tables[0].Rows[0]["SUN_SESS3_FROM"].ToString();
            Label42.Text = ds.Tables[0].Rows[0]["SUN_SESS3_TO"].ToString();


            Common_GetDoctorAppointmentsByIdBL objGetDoctorAppointmentsByIdBL = new Common_GetDoctorAppointmentsByIdBL();
            GridView1.DataSource = objGetDoctorAppointmentsByIdBL.Common_GetDoctorAppointmentsById(Convert.ToInt32(Session["doctorId"].ToString()));
            GridView1.DataBind();

            GetEmployeeLeaveBL objGetEmployeeLeaveBL = new GetEmployeeLeaveBL();
            ds = objGetEmployeeLeaveBL.GetEmployeeLeave(empId);
            if (ds.Tables[0].Rows.Count != 0)
            {
                leaveId = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
                string leaveFromDate = ds.Tables[0].Rows[0]["FROM_DATE"].ToString();
                string leaveToDate   = ds.Tables[0].Rows[0]["TO_DATE"].ToString();
                string leaveFromTime = ds.Tables[0].Rows[0]["FROM_TIME"].ToString();
                string leaveToTime   = ds.Tables[0].Rows[0]["TO_TIME"].ToString();
                Label43.Text        = "On Leave From " + leaveFromTime + " " + leaveFromDate + " to " + leaveToTime + " " + leaveToDate;
                LinkButton1.Visible = true;
            }
        }
    }

Exemple #4

Fichier : DoctorDailySchedule.aspx.cs Projet : devangsinha/Hospital-Management-System

    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            int empId = Convert.ToInt32(Session["doctorId"].ToString());

            Common_GetEmployeeScheduleBL objGetEmployeeScheduleBL = new Common_GetEmployeeScheduleBL();
            DataSet ds = new DataSet();
            ds = objGetEmployeeScheduleBL.Common_GetEmployeeSchedule(empId);
            Label1.Text = ds.Tables[0].Rows[0]["MON_SESS1_FROM"].ToString();
            Label2.Text = ds.Tables[0].Rows[0]["MON_SESS1_TO"].ToString();
            Label3.Text = ds.Tables[0].Rows[0]["MON_SESS2_FROM"].ToString();
            Label4.Text = ds.Tables[0].Rows[0]["MON_SESS2_TO"].ToString();
            Label5.Text = ds.Tables[0].Rows[0]["MON_SESS3_FROM"].ToString();
            Label6.Text = ds.Tables[0].Rows[0]["MON_SESS3_TO"].ToString();
            Label7.Text = ds.Tables[0].Rows[0]["TUE_SESS1_FROM"].ToString();
            Label8.Text = ds.Tables[0].Rows[0]["TUE_SESS1_TO"].ToString();
            Label9.Text = ds.Tables[0].Rows[0]["TUE_SESS2_FROM"].ToString();
            Label10.Text = ds.Tables[0].Rows[0]["TUE_SESS2_TO"].ToString();
            Label11.Text = ds.Tables[0].Rows[0]["TUE_SESS3_FROM"].ToString();
            Label12.Text = ds.Tables[0].Rows[0]["TUE_SESS3_TO"].ToString();
            Label13.Text = ds.Tables[0].Rows[0]["WED_SESS1_FROM"].ToString();
            Label14.Text = ds.Tables[0].Rows[0]["WED_SESS1_TO"].ToString();
            Label15.Text = ds.Tables[0].Rows[0]["WED_SESS2_FROM"].ToString();
            Label16.Text = ds.Tables[0].Rows[0]["WED_SESS2_TO"].ToString();
            Label17.Text = ds.Tables[0].Rows[0]["WED_SESS3_FROM"].ToString();
            Label18.Text = ds.Tables[0].Rows[0]["WED_SESS3_TO"].ToString();
            Label19.Text = ds.Tables[0].Rows[0]["THU_SESS1_FROM"].ToString();
            Label20.Text = ds.Tables[0].Rows[0]["THU_SESS1_TO"].ToString();
            Label21.Text = ds.Tables[0].Rows[0]["THU_SESS2_FROM"].ToString();
            Label22.Text = ds.Tables[0].Rows[0]["THU_SESS2_TO"].ToString();
            Label23.Text = ds.Tables[0].Rows[0]["THU_SESS3_FROM"].ToString();
            Label24.Text = ds.Tables[0].Rows[0]["THU_SESS3_TO"].ToString();
            Label25.Text = ds.Tables[0].Rows[0]["FRI_SESS1_FROM"].ToString();
            Label26.Text = ds.Tables[0].Rows[0]["FRI_SESS1_TO"].ToString();
            Label27.Text = ds.Tables[0].Rows[0]["FRI_SESS2_FROM"].ToString();
            Label28.Text = ds.Tables[0].Rows[0]["FRI_SESS2_TO"].ToString();
            Label29.Text = ds.Tables[0].Rows[0]["FRI_SESS3_FROM"].ToString();
            Label30.Text = ds.Tables[0].Rows[0]["FRI_SESS3_TO"].ToString();
            Label31.Text = ds.Tables[0].Rows[0]["SAT_SESS1_FROM"].ToString();
            Label32.Text = ds.Tables[0].Rows[0]["SAT_SESS1_TO"].ToString();
            Label33.Text = ds.Tables[0].Rows[0]["SAT_SESS2_FROM"].ToString();
            Label34.Text = ds.Tables[0].Rows[0]["SAT_SESS2_TO"].ToString();
            Label35.Text = ds.Tables[0].Rows[0]["SAT_SESS3_FROM"].ToString();
            Label36.Text = ds.Tables[0].Rows[0]["SAT_SESS3_TO"].ToString();
            Label37.Text = ds.Tables[0].Rows[0]["SUN_SESS1_FROM"].ToString();
            Label38.Text = ds.Tables[0].Rows[0]["SUN_SESS1_TO"].ToString();
            Label39.Text = ds.Tables[0].Rows[0]["SUN_SESS2_FROM"].ToString();
            Label40.Text = ds.Tables[0].Rows[0]["SUN_SESS2_TO"].ToString();
            Label41.Text = ds.Tables[0].Rows[0]["SUN_SESS3_FROM"].ToString();
            Label42.Text = ds.Tables[0].Rows[0]["SUN_SESS3_TO"].ToString();

            Common_GetDoctorAppointmentsByIdBL objGetDoctorAppointmentsByIdBL = new Common_GetDoctorAppointmentsByIdBL();
            GridView1.DataSource = objGetDoctorAppointmentsByIdBL.Common_GetDoctorAppointmentsById(Convert.ToInt32(Session["doctorId"].ToString()));
            GridView1.DataBind();

            GetEmployeeLeaveBL objGetEmployeeLeaveBL = new GetEmployeeLeaveBL();
            ds = objGetEmployeeLeaveBL.GetEmployeeLeave(empId);
            if(ds.Tables[0].Rows.Count != 0)
            {
                leaveId = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
                string leaveFromDate = ds.Tables[0].Rows[0]["FROM_DATE"].ToString();
                string leaveToDate = ds.Tables[0].Rows[0]["TO_DATE"].ToString();
                string leaveFromTime = ds.Tables[0].Rows[0]["FROM_TIME"].ToString();
                string leaveToTime = ds.Tables[0].Rows[0]["TO_TIME"].ToString();
                Label43.Text = "On Leave From " + leaveFromTime + " " + leaveFromDate + " to " + leaveToTime + " " + leaveToDate;
                LinkButton1.Visible = true;
            }
        }
    }