public bool addDoctor(doctor d) { dc.doctors.InsertOnSubmit(d); dc.SubmitChanges(); return(true); }
//doctor public bool EditDoctor(int id, string fn, string n, string fan, int pos, Decimal qual, bool notNull) { reloadDB(); doctor d = db.doctors.Find(id); if (d != null) { d.family_name = fn; d.name = n; d.father_name = fan; d.position = pos; /* * if (qual != null && qual != "") * d.qualification = Convert.ToInt32(qual); * else * d.qualification = null; */ if (notNull) { d.qualification = Convert.ToInt32(qual); } else { d.qualification = null; } /* * int q = Convert.ToInt32(qual); * if (q != d.qualification) * { * if (notNull) * d.qualification = q; * else * d.qualification = null; * } */ /* * string command = "UPDATE Doctor SET family_name = '" + fn + "', name = '" + n + "', father_name = '" + fan + "', position = " + pos; * if (notNull) * { * int q = Convert.ToInt32(qual); * command += ", qualification = " + q; * } * command += " WHERE id = " + id + ";"; */ try { db.SaveChanges(); //db.Database.ExecuteSqlCommand(command); return(true); } catch (Exception) { return(false); } } return(false); }
public bool editDoctor(doctor d, bool admin) { doctor dr = (from x in dc.GetTable <doctor>() where x.doctorid == d.doctorid select x).SingleOrDefault(); if (admin == true) { dr.name = d.name; dr.dob = d.dob; dr.experience = d.experience; dr.salary = d.salary; dr.field = d.field; dr.qualification = d.qualification; } //set updated values : dr.email = d.email; dr.phoneno = d.phoneno; dr.address = d.address; dr.password = d.password; dc.SubmitChanges(); //If error , return false return(true); }
//login operation public JsonResult logIn(string userName, string password, bool checkBox) { try{ bool isPresistent = (checkBox == false) ? false : true; doctor doc = getCurrentDoctorByUserName(userName); //the email will registered as name if (Membership.ValidateUser(userName, password) == true && doc != null) {//user is validated addAuthenticationCookie(userName, isPresistent); if (!db.doctorInfoes.Any(d => d.doctorID == doc.id)) {//user not founded at database return(Json(new { status = 0 }, JsonRequestBehavior.AllowGet)); } //doctor is founded at database return(Json(new { result = true }, JsonRequestBehavior.AllowGet)); } else {//user not validated return(Json(new { result = false }, JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json(new { result = false }, JsonRequestBehavior.AllowGet)); } }
//account page public ActionResult account() { //send all specialities to account page ViewBag.specialities = db.specialities.getSpecialityDataList().ToList(); //send all cities to account page ViewBag.cities = db.cities.getCityDataList().ToList(); //get the current doctor doctor oldDoctor = db.doctors.Single(doc => doc.username == User.Identity.Name); //get the account page data doctorAccountData currentDoctor = new doctorAccountData(); currentDoctor.username = oldDoctor.username; currentDoctor.bookingType = oldDoctor.bookingType; currentDoctor.cityID = db.destricts.FirstOrDefault(d => d.id == oldDoctor.destrictID).cityID; currentDoctor.destrictID = oldDoctor.destrictID; currentDoctor.mail = oldDoctor.mail; currentDoctor.password = oldDoctor.password; currentDoctor.phone = oldDoctor.phone; currentDoctor.proImage = oldDoctor.proImage; if (oldDoctor.specialities.First().superSpecialityID != null) {//doctor has sub specialities currentDoctor.spID = (byte)oldDoctor.specialities.First().superSpecialityID; currentDoctor.subSpID = oldDoctor.specialities.Select(s => s.id.ToString()).ToList(); } else {//doctor has main speciality and not subspeciality currentDoctor.spID = oldDoctor.specialities.First().id; currentDoctor.subSpID = new List <string>(); } return(View(currentDoctor)); }
//change password page public ActionResult changePassword(string userID, string password) { //this function show form that withen user can change his password try { Guid requestID = Guid.Parse(userID); resetPasswordRequest request = db.resetPasswordRequests.FirstOrDefault(r => r.id == requestID); if (request != null) { doctor doctor = db.doctors.FirstOrDefault(d => d.id == request.userID); MembershipUser docMember = Membership.GetUser(doctor.username); var generatedPass = docMember.ResetPassword(); docMember.ChangePassword(generatedPass, password); doctor.password = password; db.Entry(doctor).State = System.Data.Entity.EntityState.Modified; db.Entry(request).State = System.Data.Entity.EntityState.Deleted; Membership.UpdateUser(docMember); db.SaveChanges(); return(View(model: Resource1.passwordChangedSuccessfully)); } else { ViewBag.error = tabeeb.Areas.users.languages.Resource1.linkExpired; return(View(model: userID)); } } catch (Exception) { ViewBag.error = tabeeb.Areas.users.languages.Resource1.problemOnDoingOperationAtServer; return(View(model: userID)); } }
public ActionResult DoctorDelete(int id, doctor doc) { var UserName = doc.user_name; try { // Deleting the photo of this doctor var image = doc.photo_path; string fullPath = Server.MapPath("~/Content/images/doctors/" + image); if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(Server.MapPath("~/Content/images/doctors/" + image)); } // Deleting Doctor from doctor table and remove all profile and acount ... objDoc.commitDelete(id); Roles.RemoveUserFromRole(UserName, "doctor"); Membership.DeleteUser(UserName); return(RedirectToAction("ListDoctor")); } catch { return(View()); } }
public static doctor check_spec_name(string doc_name) { string query = String.Format("select specialist.emp_doc_specialist from employee_doctor inner join specialist On specialist.emp_doc_specialistid = employee_doctor.emp_doc_specialistid where employee_doctor.emp_doc_name = '{0}'", doc_name); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string specname = reader.GetString(0); doctor doc = new doctor(specname); return(doc); } } finally { conn.Close(); } return(null); }
public ObservableCollection <DoctorPatients> GetPatientsDoctor(doctor doc) { DentistOfficeEntities2 context = new DentistOfficeEntities2(); List <DoctorPatients> auxList = new List <DoctorPatients>(); foreach (var patient in context.patients) { int counter = 0; if (patient.idDoc == doc.idDoctor) { foreach (var appointment in context.appointments) { if (appointment.idPatient == patient.idPatient) { counter += 1; } } auxList.Add(new DoctorPatients(doc, patient, counter)); } } var a = auxList.OrderBy(si => si.NumberOfProcedures).ToList(); ObservableCollection <DoctorPatients> auxList2 = new ObservableCollection <DoctorPatients>(); auxList.Sort(new Comparison <DoctorPatients>((x, y) => x.NumberOfProcedures.CompareTo(y.NumberOfProcedures))); foreach (var patient in auxList) { auxList2.Add(patient); } return(auxList2); }
public void update(int id) { doctor p = ut.DoctorRepository.GetById(id); ut.DoctorRepository.Update(p); ut.commit(); }
public void deleteDoctorById(int id) { doctor p = ut.DoctorRepository.GetById(id); ut.DoctorRepository.Delete(p); ut.commit(); }
public void c_DeleteDoctorInDataBase() { Delete deleteClass = new Delete(); doctor testObject = new doctor(201067881, "Doctor", "Test", "male", 30000.0, "0"); Assert.IsTrue(deleteClass.delete(testObject)); }
public ActionResult Index(string currentFilter, string searchString, int?page) { var authId = User.Identity.GetUserId(); doctor dataDoctor = db.doctors.FirstOrDefault(e => e.userId == authId); ViewBag.Doctor = doctorService.DoctorAuth(authId); /*call all data from service*/ var data = doctorService.TodaySchedule(dataDoctor.userId); /*search data from name patient*/ if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; int pageNumber = (page ?? 1); int pageSize = 10; return(View(data.ToPagedList(pageNumber, pageSize))); }
public void remove(doctor d) { user user = hms.users.Where(x => x.uid == d.employee.user.uid).FirstOrDefault(); hms.users.Remove(user); hms.SaveChanges(); }
public ActionResult Create(doctor doctor) { db.doctor.Add(doctor); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <IHttpActionResult> Putdoctor(int id, doctor doctor) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != doctor.Doctor_Id) { return(BadRequest()); } db.Entry(doctor).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!doctorExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Index(string currentFilter, string searchString, int?page) { var userID = User.Identity.GetUserId(); doctor dataDoctor = db.doctors.FirstOrDefault(e => e.userId == userID); /*call all data from service*/ var data = patientService.allDoctorPatient(dataDoctor.userId); /*search data from name patient*/ if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; if (!String.IsNullOrEmpty(searchString)) { data = patientService.searchPatientFromNameAndIdDoctor(searchString, dataDoctor.id); } int pageNumber = (page ?? 1); int pageSize = 10; return(View(data.ToPagedList(pageNumber, pageSize))); }
protected void login_btn_Click(object sender, EventArgs e) { if (email_tb.Text == "admin" && password_tb.Text == "admin") { Session["admin"] = 1; Response.Redirect("AdminHome.aspx"); } DoctorClass cm = new DoctorClass(); DataClassesDataContext dc = new DataClassesDataContext(); doctor p = new doctor(); p.email = email_tb.Text; p.password = password_tb.Text; bool b = cm.login(p); if (b) { var q = from doctor in dc.GetTable <doctor>() where doctor.email == email_tb.Text && doctor.password == password_tb.Text select doctor; foreach (var a in q) { Session["doctorname"] = a.name; Session["doctorId"] = a.doctorid; } // Session["username"] = email_tb.Text; Response.Redirect("DoctorHome.aspx"); } else { error.Text = "email or password is incorrect"; //Response.Redirect("login.aspx"); } }
//get doctor advices as json string public JsonResult doctorAdvices(int pageNumber = 1, byte pageSize = 10, string doctorID = null) { try { doctor doctor = null; if (doctorID == null) { doctor = getCurrentDoctor(); } else { Guid id = Guid.Parse(doctorID); db.doctors.Single(d => d.id == id); } var doctorAdvices = doctor.advices.Select(ad => new { date = ad.dateOfJoin, content = ad.adviceContent, ad.id, comments = ad.commentOnAdvices.Count(c => c.comment != null), likes = ad.commentOnAdvices.Count(c => c.like == true), shares = ad.commentOnAdvices.Count(c => c.share == true), seens = ad.commentOnAdvices.Count(c => c.like == true || c.comment != null || c.share == true) }) .OrderByDescending(c => c.date) .Skip((pageNumber - 1) * pageSize).Take(pageSize) .Select(c => new { c.id, c.content, c.comments, c.likes, c.seens, c.shares }).ToList(); return(Json(new { status = true, data = doctorAdvices, total = doctor.advices.Count }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { status = false }, JsonRequestBehavior.AllowGet)); } }
public HttpResponseMessage Put(int id, doctor Doctor) { using (multimedia_db2Entities1 db = new multimedia_db2Entities1()) { try { var doctor = db.doctors.FirstOrDefault(d => d.id == id); if (Doctor == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There is no such user")); } else { doctor.doctorNmae = Doctor.doctorNmae; doctor.doctorMail = Doctor.doctorMail; doctor.doctorImage = Doctor.doctorImage; doctor.doctorTitle = Doctor.doctorTitle; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, Doctor)); } } catch (Exception exc) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exc)); } } }
public void b_editDoctorInDataBase() { Edit editClass = new Edit(); doctor testObject = new doctor(201067881, "Doctor", "Test", "male", 30000.0, "0"); Assert.IsTrue(editClass.editParam(testObject, "firstName", "editTest")); }
public async Task <doctor> createdoctor(doctor doctor1) { HttpClient client = new HttpClient(); client.BaseAddress = new Uri("http://slamtk1.somee.com/api/odata/DoctorsGet"); var json = JsonConvert.SerializeObject(doctor1); var content = new StringContent(json, Encoding.UTF8, "application/json"); HttpRequestMessage h = new HttpRequestMessage(); h.Content = content; h.Method = HttpMethod.Post; h.RequestUri = client.BaseAddress; HttpResponseMessage response = await client.SendAsync(h); if (response.IsSuccessStatusCode) { var response1 = await response.Content.ReadAsStringAsync(); doctor result = JsonConvert.DeserializeObject <doctor>(response1); doctor result1 = result; return(result1); } else { doctor dc2 = new doctor() { ID = 0, }; return(dc2); } }
public static doctor doc_specialist(string name) { string query = String.Format("select emp_doc_specialistid from employee_doctor where emp_doc_name = '{0}'", name); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int spec_id = reader.GetInt32(0); doctor doc = new doctor(spec_id); return(doc); } } finally { conn.Close(); } return(null); }
public static doctor doc_specialist_id(int spc_id) { string query = String.Format("select emp_doc_specialist from specialist where emp_doc_specialistid = {0}", spc_id); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string specname = reader.GetString(0); doctor doc = new doctor(specname); return(doc); } } finally { conn.Close(); } return(null); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Columns[e.ColumnIndex].HeaderText == "Delete") { if (MessageBox.Show("Do you want to delete this " + type + " ?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes) { int dni = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[2].Value); int personId = servPerson.GetPersonByDni(dni).ID; if (type == "Nurse") { nurse objNurse = new nurse(); objNurse = nurseService.GetNurseByPersonId(personId); nurseService.DeleteNurse(objNurse.id); } else if (type == "Doctor") { doctor objDoctor = new doctor(); objDoctor = doctorService.GetDoctorByPersonId(personId); doctorService.DeleteDoctor(objDoctor.id); } else if (type == "Patient") { patient objPatient = new patient(); objPatient = patientService.GetPatientByPersonId(personId); patientService.DeletePatient(objPatient.id); } dataGridView1.DataBindings.Clear(); loadPersons(); } } }
protected void register_btn_Click(object sender, EventArgs e) { AdminClass a = new AdminClass(); //Create Patient class and assign values to it. doctor d = createDoctorObject(); bool alreadyRegistered = a.registered(d); if (alreadyRegistered) { ErrorL.Text = "Already Registered"; } else { //Register Patient bool registerSucceeded = a.addDoctor(d); if (registerSucceeded == true) { Response.Redirect("AdminViewDoctor.aspx"); } else { ErrorL.Text = "Whoops"; } } }
// GET: Hotel/Edit/5 public ActionResult Edit(int id) { doctor h = a.getDoctorById(id); a.deleteDoctorById(id); return(View(h)); }
protected void Page_Init(object sender, EventArgs e) { DoctorClass ac = new DoctorClass(); if (Session["EditDrId"] == null) { Server.Transfer("AdminViewDoctor.aspx"); } d = ac.getDoctor(Int32.Parse(Session["EditDrId"].ToString())); ErrorL.Text = Session["EditDrId"].ToString(); //Set PresentValues //Copy paste from DoctorEditProfile if (!this.IsPostBack) { dob.Text = d.dob.ToString("dd-MM-yyyy"); Salary.Text = d.salary.ToString(); first_name_tb.Text = d.name; Email_tb.Text = d.email; phoneno_tb.Text = d.phoneno; Address_tb.Text = d.address; Field.Text = d.field; Qualification.Text = d.qualification; } }
//get doctor patient views as json string public JsonResult doctorPatientViews(int pageNumber = 1, byte pageSize = 10, string doctorID = null) { try { doctor doctor = null; if (doctorID == null) { doctor = getCurrentDoctor(); } else { Guid id = Guid.Parse(doctorID); doctor = db.doctors.Single(d => d.id == id); } var patientViews = doctor.patientViews.Select(pv => new { comment = (pv.comment == null)?"":pv.comment, patientName = pv.patient.username, pv.rate }) .OrderByDescending(a => a.rate) .Skip((pageNumber - 1) * pageSize).Take(pageSize) .ToList(); var count = doctor.patientViews.Count; return(Json(new { status = true, data = patientViews, total = count }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new{ doctorStatus = false }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create([Bind(Include = "id,password,gender,first_Name,last_Name,email,phone_number,role")] user user) { if (ModelState.IsValid) { user.last_LoginTime = DateTime.Now; //deploy role if (user.role == "Doctor") { doctor doctor = new doctor(); doctor.id = user.id; db.doctors.Add(doctor); } else if (user.role == "Administrator") { administrator administrator = new administrator(); administrator.id = user.id; db.administrators.Add(administrator); } else if (user.role == "Stomalogist") { stomatologist stomatologist = new stomatologist(); stomatologist.id = user.id; db.stomatologists.Add(stomatologist); } else { ModelState.AddModelError("", "Please enter correct role"); return(View()); } db.users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } List <SelectListItem> roleList = new List <SelectListItem>() { new SelectListItem() { Text = "Administrator", Value = "Administrator", }, new SelectListItem { Text = "Doctor", Value = "Doctor", }, new SelectListItem { Text = "Stomalogist", Value = "Stomalogist", } }; ViewBag.roleSelectList = new SelectList(roleList, "Value", "Text"); return(RedirectToAction("Index", "Administrators")); }
public bool commitInsert(string _fname, string _lname, string _uname, string _pass, int _phone, string _email) { doctorsDataContext objDoctorDC = new doctorsDataContext(); using (objDoctorDC) { doctor objNewDoctor = new doctor(); objNewDoctor.firstname = _fname; objNewDoctor.lastname = _lname; objNewDoctor.username = _uname; objNewDoctor.passwd = _pass; objNewDoctor.phone = _phone; objNewDoctor.email = _email; objDoctorDC.doctors.InsertOnSubmit(objNewDoctor); objDoctorDC.SubmitChanges(); return true; } }
public ActionResult addDoc() { string name = Request.Form["name"]; string address = Request.Form["address"]; int supplierId = int.Parse(Request.Form["supplier"]); teethLabEntities db = new teethLabEntities(); doctor doc = new doctor(); doc.name = name; doc.address = address; doc.depit = 0; doc.isActive = false; if (supplierId != 0) doc.supplierId = supplierId; db.doctors.Add(doc); db.SaveChanges(); return Redirect(Url.Action("Index", "Doctor")); }
partial void Updatedoctor(doctor instance);
partial void Deletedoctor(doctor instance);
partial void Insertdoctor(doctor instance);
public bool addnewdoctor(doctor doc) { this.context.doctors.Add(doc); this.context.SaveChanges(); this.context = new teethLabEntities(); return true; }