Exemple #1
0
        //Appointment Search=====================
        public int appointmentView()
        {
            DB_Operations db = new DB_Operations();


            try
            {
                string sql = "SELECT * FROM Appointments WHERE  DoctorID =" + DoctorID + " AND Date = '" + Date + "'";

                ds = db.exesearchQuery(sql);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        //Search
        public int search()
        {
            DB_Operations db = new DB_Operations();

            try
            {
                string  sql = "SELECT * FROM NeerogaUsers WHERE UserID = " + UserID;
                DataSet ds  = db.exesearchQuery(sql);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    UserID   = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                    UserName = ds.Tables[0].Rows[0][1].ToString();
                    Password = ds.Tables[0].Rows[0][2].ToString();
                    UserType = ds.Tables[0].Rows[0][3].ToString();
                    Age      = Convert.ToInt32(ds.Tables[0].Rows[0][4].ToString());
                    City     = ds.Tables[0].Rows[0][5].ToString();
                    Gender   = ds.Tables[0].Rows[0][6].ToString();
                    TP_No    = Convert.ToInt32(ds.Tables[0].Rows[0][7].ToString());
                    Category = ds.Tables[0].Rows[0][8].ToString();

                    return(1);
                }
                else
                {
                    return(0);
                }
            }

            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #3
0
        public int userlogin(int id)
        {
            this.ID = id;
            DB_Operations db = new DB_Operations();

            try
            {
                string  sql = "SELECT * FROM NeerogaUsers WHERE UserID = " + ID + "";
                DataSet ds  = db.exesearchQuery(sql);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    ID       = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                    Password = ds.Tables[0].Rows[0][2].ToString();
                    UserType = ds.Tables[0].Rows[0][3].ToString();

                    return(1);
                }
                else
                {
                    return(0);
                }
            }

            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #4
0
        //search==========
        public int search()
        {
            DB_Operations db = new DB_Operations();


            try
            {
                //string sql = "SELECT * FROM PatientDetails WHERE "  + DoctorID + " ";

                string sql = "SELECT Max(AppointmentID) from Appointments";
                ds = db.exesearchQuery(sql);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    AppointmentID = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());

                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        //Seerch records
        public int RecordSearch()
        {
            DB_Operations db = new DB_Operations();


            try
            {
                string sql = "SELECT * FROM PatientRecords where AppointmentID = " + AppointmentID + " ";

                ds = db.exesearchQuery(sql);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #6
0
        //SEARCH CODE
        public int search()
        {
            DB_Operations db = new DB_Operations();


            try
            {
                string sql = "SELECT * FROM PatientDetails WHERE " + cname + " LIKE '%" + sname + "%' ";


                ds = db.exesearchQuery(sql);


                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #7
0
        //SEARCH CODE
        public int search()
        {
            DB_Operations db = new DB_Operations();


            try
            {
                string sql = "SELECT * FROM Doctor_Availability WHERE  UserID = " + DoctorID + " ";


                ds = db.exesearchQuery(sql);


                if (ds.Tables[0].Rows.Count > 0)
                {
                    //PatientID = ds.Tables[0].Rows[0][0].ToString();
                    //PatientName = ds.Tables[0].Rows[0][1].ToString();
                    //PatientContact = ds.Tables[0].Rows[0][2].ToString();
                    //PatientAge = Convert.ToInt32(ds.Tables[0].Rows[0][3].ToString());

                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #8
0
        //Search Availabiity

        public int Doctor_AvailabilitySearch()
        {
            DB_Operations db = new DB_Operations();


            try
            {
                string sql = "SELECT * FROM Doctor_Availability where UserID = " + DoctorID + " ";

                ds = db.exesearchQuery(sql);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        //Datatable
        public DataTable gettable()
        {
            DB_Operations db = new DB_Operations();

            try
            {
                string  sql = "select * from NeerogaUsers";
                DataSet ds  = db.exesearchQuery(sql);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds.Tables[0]);
                }
                else
                {
                    return(ds.Tables[0]);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }