public ActionResult agregarDoctor(string nombre, string apellido, string cedula, DateTime fechaNacimiento, string sexo, string direccion, string telefono, int[] especialidades) { Entities model = new Entities(); DOCTOR doctor = new DOCTOR(); doctor.NOMBRE = nombre; doctor.APELLIDO = apellido; doctor.CEDULA = cedula; doctor.FECHA_NACIMIENTO = fechaNacimiento; doctor.SEXO = sexo; doctor.DIRECCION = direccion; doctor.TELEFONO = telefono; doctor.VISIBLE = true; model.DOCTOR.Add(doctor); model.SaveChanges(); foreach (int id in especialidades) { DOCTOR_ESPECIALIDAD de = new DOCTOR_ESPECIALIDAD(); de.ID_DOCTOR = doctor.ID; de.ID_ESPECIALIDAD = id; de.VISIBLE = true; model.DOCTOR_ESPECIALIDAD.Add(de); } model.SaveChanges(); return(Json(doctor)); }
public DOCTOR getDoctorsByID(int id) { var temp = basedao.getDoctor(id, null, null, null, null, null, null, null); DOCTOR result = null; try { result = temp.First(); } catch (System.InvalidOperationException e) { Console.WriteLine(e); return(null); } catch (System.ArgumentNullException e) { Console.WriteLine(e); return(null); } catch (Exception e) { Console.WriteLine(e); return(null); } return(result); }
public ActionResult nuevoDoctor(DOCTOR obj) { if (!ModelState.IsValid) { ViewBag.distrito = new SelectList(ListDistrito(), "IDE_DIS", "NOM_DIS"); ViewBag.especialidad = new SelectList(ListEspecialidad(), "IDE_ESP", "DES_ESP"); return(View(obj)); } HttpClient clienteHttp = new HttpClient(); clienteHttp.BaseAddress = new Uri("http://localhost/ApiCL3/"); var request = clienteHttp.PostAsync("api/Doctor", obj, new JsonMediaTypeFormatter()).Result; if (request.IsSuccessStatusCode) { var resultString = request.Content.ReadAsStringAsync().Result; var estado = JsonConvert.DeserializeObject <int>(resultString); if (estado == 1) { ViewBag.distrito = new SelectList(ListDistrito(), "IDE_DIS", "NOM_DIS"); ViewBag.especialidad = new SelectList(ListEspecialidad(), "IDE_ESP", "DES_ESP"); ViewBag.mensaje = estado + " Empleado registrado correctamente..!!"; return(View(obj)); } return(View(obj)); } return(View()); }
public ActionResult Edit(DOCTOR DOCTOR) { if (ModelState.IsValid) { /* * db.Entry(DOCTOR).State = EntityState.Modified; * db.SaveChanges(); * return RedirectToAction("index"); */ var userid = Global.CurrentUserID; var DOCTOR_ID = userid; if (DOCTOR_ID < 0) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //var DOCTOR_ID = "123";//change var p = db.DOCTOR.Find(DOCTOR_ID); p.DOCTOR_NM = DOCTOR.DOCTOR_NM; p.GENDER = DOCTOR.GENDER; p.AGE = DOCTOR.AGE; p.TEL = DOCTOR.TEL; p.SECTION_ID = DOCTOR.SECTION_ID; p.DISEASE_ID = DOCTOR.DISEASE_ID; p.INTRODUCTION = DOCTOR.INTRODUCTION; p.PHOTO_URL = DOCTOR.PHOTO_URL; db.SaveChanges(); } return(RedirectToAction("Index")); }
void AddDocTor() { try { if (idfield.Text.Length == 0 || specialityfield.Text.Length == 0 || namefield.Text.Length == 0) { throw new Exception("Eror"); } if (int.TryParse(idfield.Text, out int number)) { DOCTOR dOCTOR = new DOCTOR() { Id = number, Name = namefield.Text, Speciality = specialityfield.Text }; AddDoctor(dOCTOR); AllUpdate(); } else { throw new Exception("Eror parse!"); } } catch (Exception er) { MessageBox.Show(er.Message, "Text length = 0!"); } }
public ActionResult Create( [Bind(Include = "DOCTOR_ID,DOCTOR_NM,GENDER,AGE,TEL,PHOTO_URL,SECTION_ID,DISEASE_ID,INTRODUCTION,INSDATE,PATIENT_ID,PATIENT_NM")] V_DOCTORINFO info) { var doctor = new DOCTOR() { DOCTOR_ID = info.DOCTOR_ID, DOCTOR_NM = info.DOCTOR_NM, GENDER = info.GENDER, AGE = info.AGE, DISEASE_ID = info.DISEASE_ID, INTRODUCTION = info.INTRODUCTION, SECTION_ID = info.SECTION_ID, TEL = info.TEL, INSDATE = DateTime.Now, }; if (ModelState.IsValid) { db.DOCTOR.Add(doctor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(info)); }
public ActionResult DeleteConfirmed(int id) { DOCTOR dOCTOR = db.DOCTORS.Find(id); db.DOCTORS.Remove(dOCTOR); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "dpi,nombre,direccion,telefono,puesto,sueldo")] DOCTOR dOCTOR) { if (ModelState.IsValid) { db.Entry(dOCTOR).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dOCTOR)); }
public ActionResult DoctorRegistration(DOCTOR Doc) { if (ModelState.IsValid) { db.DOCTORS.Add(Doc); db.SaveChanges(); return(RedirectToAction("")); } return(View()); }
public ActionResult Edit([Bind(Include = "DOCTOID,NAME,SURNAME,DOB,ADDRESS,STREET,POSTCODE,MOBILE")] DOCTOR doctor) { if (ModelState.IsValid) { db.Entry(doctor).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(doctor)); }
public ActionResult Edit([Bind(Include = "DOCTORID,DOCTORNAME,DOCTORADDRESS,DOCTOREmail,DOCTORTelePhone,DOCTORWorkingHours,ClinicID,CLINICGoogleUID,ClinicName,USERID,USERNAME,USERSearchDATETIME")] DOCTOR dOCTOR) { if (ModelState.IsValid) { db.Entry(dOCTOR).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClinicID = new SelectList(db.CLINICS, "ClinicID", "CLINICGoogleUID", dOCTOR.ClinicID); return(View(dOCTOR)); }
public ActionResult Create([Bind(Include = "DOCTOID,NAME,SURNAME,DOB,ADDRESS,STREET,POSTCODE,MOBILE")] DOCTOR dOCTOR) { if (ModelState.IsValid) { db.DOCTORS.Add(dOCTOR); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dOCTOR)); }
public IHttpActionResult Add() { using (HIST_CLINEntities bd = new HIST_CLINEntities()) { var objDOCTOR = new DOCTOR(); objDOCTOR.nombre_doctor = "Stephen"; objDOCTOR.apellido_doctor = "Paucara"; bd.DOCTOR.Add(objDOCTOR); bd.SaveChanges(); } return(Ok("Nuevo registro exitoso")); }
public ActionResult Create([Bind(Include = "dpi,nombre,direccion,telefono,puesto,sueldo")] DOCTOR dOCTOR) { if (ModelState.IsValid) { db.DOCTOR.Add(dOCTOR); db.SaveChanges(); long?enviar = dOCTOR.dpi; return(RedirectToAction("Create", "ESPECIALIDAD_DOCTOR", new { dpi = enviar })); } return(View(dOCTOR)); }
public ActionResult DoctorEditInfo(DOCTOR Doc) { if (ModelState.IsValid) { db.Entry(Doc).State = EntityState.Modified;; db.SaveChanges(); return(Redirect("/Account/DoctorDashboard")); } else { return(HttpNotFound()); } }
public ActionResult DoctorRegisteration(DOCTOR Doc) { if (ModelState.IsValid) { db.DOCTORS.Add(Doc); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(HttpNotFound()); } }
public int Put(DOCTOR objD) { var unDoctor = db.DOCTOR.Where(p => p.IDE_DOC == objD.IDE_DOC).FirstOrDefault(); unDoctor.IDE_DOC = objD.IDE_DOC; unDoctor.NOM_DOC = objD.NOM_DOC; unDoctor.APE_DOC = objD.APE_DOC; unDoctor.IDE_ESP = objD.IDE_ESP; unDoctor.TEL_DOC = objD.TEL_DOC; unDoctor.COR_DOC = objD.COR_DOC; unDoctor.IDE_DIS = objD.IDE_DIS; return(db.SaveChanges()); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DOCTOR doctor = db.DOCTORS.Find(id); if (doctor == null) { return(HttpNotFound()); } return(View(doctor)); }
// GET: DOCTORs/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DOCTOR dOCTOR = db.DOCTORS.Find(id); if (dOCTOR == null) { return(HttpNotFound()); } return(View(dOCTOR)); }
public List <string> DoctorLogin(string prefix, string profix) { string UserName = prefix.Trim(); string Password = profix.Trim(); List <string> Doc = new List <string>(); try { DOCTOR d = db.DOCTORS.Where(a => a.UserName == UserName && a.Password == Password).FirstOrDefault(); Doc.Add(d.Id.ToString()); Doc.Add(d.FullName); } catch { Doc.Add("error"); } return(Doc); }
// GET: DOCTORs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DOCTOR dOCTOR = db.DOCTORS.Find(id); if (dOCTOR == null) { return(HttpNotFound()); } ViewBag.ClinicID = new SelectList(db.CLINICS, "ClinicID", "CLINICGoogleUID", dOCTOR.ClinicID); return(View(dOCTOR)); }
public void LoadDoctors() { SqlConnection connection = new SqlConnection(MyProject.Properties.Settings.Default.Connection); try { connection.Open(); } catch (Exception ex) { connection = new SqlConnection(MyProject.Properties.Settings.Default.Connection); connection.Open(); SqlCommand command = connection.CreateCommand(); using (FileStream fstream = File.OpenRead("SQLQuery2.sql")) { // преобразуем строку в байты byte[] array = new byte[fstream.Length]; // считываем данные fstream.Read(array, 0, array.Length); // декодируем байты в строку string textFromFile = Encoding.Default.GetString(array); command.CommandText = textFromFile; command.ExecuteNonQuery(); } } finally { string selectdoc = $"select * from DOCTOR "; SqlCommand commanddoc = new SqlCommand(selectdoc, connection); using (SqlDataReader reader = commanddoc.ExecuteReader()) { while (reader.Read()) { Admin doctors = new Admin(reader.GetInt32(0)); doctors.IDdoctor = reader.GetInt32(0); doctors.Doctor = reader.GetString(2); doctors.Specialization = reader.GetString(3); doctors.Experience =Convert.ToString(reader.GetValue(4)); doctors.Room = reader.GetInt32(5); DOCTOR.Add(doctors); } } connection.Close(); } }
public ActionResult DoctorLogin(DOCTOR Doc) { if (ModelState.IsValid) { var details = (from DoctorList in db.DOCTORS where DoctorList.UserName == Doc.UserName && DoctorList.Password == Doc.Password select new { DoctorList.Id, DoctorList.FirstName, DoctorList.LastName }).ToList(); if (details.FirstOrDefault() != null) { Session["DoctorId"] = details.FirstOrDefault().Id; Session["DoctorName"] = details.FirstOrDefault().FirstName + " " + details.FirstOrDefault().LastName; return(RedirectToAction("DoctorDashboard", "Account")); } } else { ModelState.AddModelError("", "Error"); } return(View(Doc)); }
public DOCTOR DoctorLogin(string email, string password, string random) { int ID = dao.getDoctorIdByEmail(email); DOCTOR result = dao.getDoctorsByID(ID); if (result != null) { if (code((result).PASSWORD + random).Equals(password.ToLower())) { return(result); } else { return(null); } } else { return(null); } }
private void btnTambahDok_Click(object sender, RoutedEventArgs e) { if (cmbPoli.Text == "Khusus") { DOCTOR dokterkhusus = new DOCTOR() { NAME = txtNamaDok.Text, EMAIL = txtEmailDok.Text, ADDRESS = txtAlamatDok.Text, PHONE = txtNoTelpDok.Text, GENDER = getJenisKelaminDokter(), SPECIALIST_ID = Convert.ToInt32(cmbSpecialis.SelectedValue), POLY_ID = Convert.ToInt32(cmbPoli.SelectedValue) }; et.DOCTORs.Add(dokterkhusus); et.SaveChanges(); clearTextDokter(); dgDokter.UnselectAllCells(); this.ViewDokterSpecialis(dgDokter); MessageBox.Show("Tambah Data Dokter Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); } else if (cmbPoli.Text == "Umum") { DOCTOR dokterumum = new DOCTOR() { NAME = txtNamaDok.Text, EMAIL = txtEmailDok.Text, ADDRESS = txtAlamatDok.Text, PHONE = txtNoTelpDok.Text, GENDER = getJenisKelaminDokter(), POLY_ID = Convert.ToInt32(cmbPoli.SelectedValue) }; et.DOCTORs.Add(dokterumum); et.SaveChanges(); clearTextDokter(); dgDokter.UnselectAllCells(); this.ViewDokterNonSpecialis(dgDokter); MessageBox.Show("Tambah Data Dokter Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); } }
public JsonResult DoctorAjaxRegistration(string FirstName, string LastName, string FatherName, int Specialization, int Specialty1, int?Specialty2, int?Specialty3, string Country, int City, string Address, string Phone, string Mobile, string Password) { if (Specialty2 == 0) { Specialty2 = null; } if (Specialty3 == 0) { Specialty3 = null; } int id = db.DOCTORS.Max(a => a.Id) + 1; string username = FirstName + "_" + id; DOCTOR doc = new DOCTOR() { FirstName = FirstName, LastName = LastName, FatherName = FatherName, FullName = FirstName + " " + FatherName + " " + LastName, specialization = Specialization, Specialty1 = Specialty1, Specialty2 = Specialty2, Specialty3 = Specialty3, Country = Country, City = City, Address = Address, Phone = Phone, Mobile = Mobile, UserName = username, Password = Password }; try { db.DOCTORS.Add(doc); db.SaveChanges(); return(Json(username, JsonRequestBehavior.AllowGet)); } catch { return(Json(0, JsonRequestBehavior.AllowGet)); } }
private void btnEditDok_Click(object sender, RoutedEventArgs e) { object item = dgDokter.SelectedItem; string temp_id = (dgDokter.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text; int id = Convert.ToInt32(temp_id); DOCTOR dokter = SearchByIdDokter(id); if (cmbPoli.Text == "Khusus") { dokter.NAME = txtNamaDok.Text; dokter.EMAIL = txtEmailDok.Text; dokter.ADDRESS = txtAlamatDok.Text; dokter.PHONE = txtNoTelpDok.Text; dokter.SPECIALIST_ID = Convert.ToInt32(cmbSpecialis.SelectedValue); dokter.POLY_ID = Convert.ToInt32(cmbPoli.SelectedValue); dokter.GENDER = getJenisKelaminDokter(); et.Entry(dokter).State = System.Data.Entity.EntityState.Modified; et.SaveChanges(); clearTextDokter(); this.ViewDokterSpecialis(dgDokter); MessageBox.Show("Update Data Dokter Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); } else if (cmbPoli.Text == "Umum") { dokter.NAME = txtNamaDok.Text; dokter.EMAIL = txtEmailDok.Text; dokter.ADDRESS = txtAlamatDok.Text; dokter.PHONE = txtNoTelpDok.Text; dokter.POLY_ID = Convert.ToInt32(cmbPoli.SelectedValue); dokter.GENDER = getJenisKelaminDokter(); et.Entry(dokter).State = System.Data.Entity.EntityState.Modified; et.SaveChanges(); clearTextDokter(); this.ViewDokterNonSpecialis(dgDokter); MessageBox.Show("Update Data Dokter Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void deleteClick2(object sender, RoutedEventArgs e) { try { if (doctorGrid.SelectedItems.Count > 0) { for (int i = 0; i < doctorGrid.SelectedItems.Count; i++) { DOCTOR doctor = doctorGrid.SelectedItems[i] as DOCTOR; if (doctor != null) { db.DOCTOR.Remove(doctor); } } } db.SaveChanges(); doctorGrid.ItemsSource = db.DOCTOR.Local.ToBindingList(); } catch (Exception) { MessageBox.Show("Выберите строку и повторите.", "Error", MessageBoxButton.OK, MessageBoxImage.Error); doctorGrid.ItemsSource = db.DOCTOR.Local.ToBindingList(); } }
public void AddDoctor(DOCTOR doctor) { DatMan DatMan = new DatMan(); Hospital hospital = new Hospital(); hospital = DatMan.ReadToObject <Hospital>(); bool e = false; foreach (var el in hospital.ds) { if (el.Id.ToString() == idfield.Text) { e = true; } } if (e == false) { hospital.ds.Add(doctor); DatMan.Write(hospital); } else { ShowMesText(messege1, "Врач с таким Id уже существует!!!"); } }
static void Main(string[] args) { Console.ForegroundColor = ConsoleColor.Yellow; DOCTOR dOCTOR = new DOCTOR() { Id = 10, Name = "Maxs", Speciality = "Oftalmolog" }; Patient patient = new Patient() { age = 10, Id = 121, Name = "Andrey" }; Visit visit = new Visit() { Id = 1, DoctorId = dOCTOR.Id, PatientId = patient.Id, time = DateTime.Now, Diagnostik = "eye", Reason = "terible" }; Console.WriteLine(dOCTOR); Console.WriteLine(patient); Console.WriteLine(visit); Hospital hospital = new Hospital(); hospital.ds.Add(dOCTOR); hospital.patients.Add(patient); hospital.visits.Add(visit); hospital.ds.Add(dOCTOR); hospital.patients.Add(patient); hospital.visits.Add(visit); hospital.ds.Add(dOCTOR); hospital.patients.Add(patient); hospital.visits.Add(visit); //DatMan datMan = new DatMan(); //datMan.Write(hospital); //datMan.ReadToObject(); }