public List <patientdata> patdashboard(int loginid)
        {
            database_class     data    = new database_class();
            var                appoint = from i in data.Appointments where i.LoginId == loginid select i;
            List <patientdata> apd     = new List <patientdata>();

            foreach (var i in appoint)
            {
                patientdata app = new patientdata();
                app.AppointmentId = i.AppointmentId;
                app.Status        = i.Status;
                app.Slot          = i.Slot;
                app.Timings       = i.Timimgs;
                app.Pay           = i.Pay;
                app.Description   = i.Description;
                app.Prescription  = i.Prescription;
                apd.Add(app);
            }
            return(apd);
        }
        public List <patientdata> docdashboard(int loginid)
        {
            database_class     database = new database_class();
            int                docid    = (from i in database.Doctors where i.LoginId == loginid select i.DoctorId).FirstOrDefault();
            var                appoint  = from i in database.Appointments where i.DoctorId == docid select i;
            List <patientdata> pat      = new List <patientdata>();

            foreach (var i in appoint)
            {
                patientdata patdata = new patientdata();
                patdata.AppointmentId = i.AppointmentId;
                patdata.Status        = i.Status;
                patdata.Timings       = i.Timimgs;
                patdata.Slot          = i.Slot;
                patdata.Pay           = i.Pay;
                patdata.Description   = i.Description;
                pat.Add(patdata);
            }
            return(pat);
        }