public IActionResult postDoctor(Doctor doctor)
{
try
{
context.Add <Doctor>(doctor);
context.SaveChanges();
return(CreatedAtAction("getDoctor", new { id = doctor.IdDoctor }, doctor));
}
catch (DbUpdateException)
{
return(this.BadRequest("nie dodano"));
}
}
public IActionResult AddDoctor(DoctorDTO doctorDTO)
{
Doctor doctor = new Doctor();
doctor.FirstName = doctorDTO.FirstName;
doctor.LastName = doctorDTO.LastName;
doctor.Email = doctorDTO.Email;
hospitalContext.Doctors.Add(doctor);
hospitalContext.SaveChanges();
return(Ok(doctor));
}
public ActionResult Create([Bind(Include = "IdCitas,Paciente_Id,Medico_Id,Fecha,Hora")] Citas citas)
{
if (ModelState.IsValid)
{
db.Citas.Add(citas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Medico_Id = new SelectList(db.Medicos, "IdMedicos", "Nombre", citas.Medico_Id);
ViewBag.Paciente_Id = new SelectList(db.Pacientes, "IdPacientes", "Cedula", citas.Paciente_Id);
return(View(citas));
}
public ActionResult Create([Bind(Include = "Id,Job_id,Name,Email,Phone,CV,Text,Date")] Job_applications job_application)
{
if (ModelState.IsValid)
{
job_application.Date = DateTime.Now;
db.Job_applications.Add(job_application);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Job_id = new SelectList(db.Jobs, "Id", "Title", job_application.Job_id);
return(View("Admin/Create", job_application));
}
// Salva ou atualiza um objeto
public void SalvarObjeto(Consulta objeto)
{
try
{
// marca os attributos que são objetos como já existentes evitando a duplicação
ctx.Entry(objeto.Paciente).State = System.Data.Entity.EntityState.Unchanged;
ctx.Entry(objeto.Paciente.Convenio).State = System.Data.Entity.EntityState.Unchanged;
//----------
// Objetos (class) que possuem mais de um objeto (class) aninhado
// e melhor buscar pelo ctx do que marcar como nao alterado
//----------
// seleciona um medico ja existente para atribuir ao objeto
// evitando a duplicação do registro
var medicoQuery = from medico
in ctx.Medicos.Include("Banco").Include("AreaAtuacao")
where medico.Id == objeto.Medico.Id
select medico;
objeto.Medico = medicoQuery.ToList().ElementAt(0);
// seleciona um agendamento ja existente para atribuir ao objeto
// evitando a duplicação do registro
var agendamentoQuery = from agendamento
in ctx.Agendamentos.Include("Paciente").Include("Medico").Include("Secretaria")
where agendamento.Id == objeto.Agendamento.Id
select agendamento;
objeto.Agendamento = agendamentoQuery.ToList().ElementAt(0);
if (objeto.Id == 0)
{
ctx.Consultas.Add(objeto);
}
else
{
var tempObjeto = ctx.Consultas.SingleOrDefault(temp => temp.Id == objeto.Id);
tempObjeto.Id = objeto.Id;
tempObjeto.Paciente = objeto.Paciente;
tempObjeto.Medico = objeto.Medico;
tempObjeto.Agendamento = objeto.Agendamento;
tempObjeto.Data = objeto.Data;
tempObjeto.PrecoTotal = objeto.PrecoTotal;
}
ctx.SaveChanges();
}
catch (Exception ex)
{
Util.HandleSQLDBException(ex);
}
}
public void createMedico(Medico medico)
{
if (medico.conta != null)
{
ctx.Entry(medico.conta).State = System.Data.Entity.EntityState.Unchanged;
}
if (medico.Especialidade != null)
{
ctx.Entry(medico.Especialidade).State = System.Data.Entity.EntityState.Unchanged;
}
ctx.Medicos.Add(medico);
ctx.SaveChanges();
}
public IActionResult updateDoctor(Doctor doctor)
{
Doctor d = context.doctor.Find(doctor.IdDoctor);
if (d == null)
{
return(NotFound("Doctor o takim id nieistnieje"));
}
context.Database.BeginTransaction();
context.Entry(d).CurrentValues.SetValues(doctor);
context.SaveChanges();
context.Database.CommitTransaction();
return(Ok(doctor));
}
public ActionResult Create([Bind(Include = "BookingID,DoctorID,NurseID,PatientID")] Booking booking)
{
if (ModelState.IsValid)
{
db.Bookings.Add(booking);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DoctorID = new SelectList(db.Doctors, "DoctorID", "DoctorName", booking.DoctorID);
ViewBag.NurseID = new SelectList(db.Nurses, "NurseID", "NurseName", booking.NurseID);
ViewBag.PatientID = new SelectList(db.Patients, "PatientID", "PatientName", booking.PatientID);
return(View(booking));
}
public ActionResult Create([Bind(Include = "Name,Role,Subject,Content,Rate,DepartmentId")] Testimonial testimonial)
{
try
{
if (this.IsCaptchaValid("Captcha is not valid."))
{
if (ModelState.IsValid)
{
var DirtyWords = db.DirtyWords.ToList();
foreach (var row in DirtyWords)
{
if ((testimonial.Content.Contains(row.Word)) || (testimonial.Subject.Contains(row.Word)))
{
testimonial.Timestamp = DateTime.Now;
testimonial.Reviewed = "PENDING";
db.Testimonials.Add(testimonial);
db.SaveChanges();
TempData["SuccessMessage"] = "Your testimonial has been successfully submitted.";
return(RedirectToAction("Index"));
}
}
testimonial.Timestamp = DateTime.Now;
testimonial.Reviewed = "NO";
db.Testimonials.Add(testimonial);
db.SaveChanges();
TempData["SuccessMessage"] = "Your testimonial has been successfully submitted.";
return(RedirectToAction("Index"));
}
ViewBag.ErrorCaptcha = "Captcha is not valid.";
return(View(testimonial));
}
ViewBag.departments = db.departments.ToList();
return(View(testimonial));
}
catch (DbUpdateException dbException)
{
ViewBag.DbExceptionMessage = dbException.Message;
}
catch (SqlException sqlException)
{
ViewBag.SqlException = sqlException.Message;
}
catch (Exception genericException)
{
ViewBag.ExceptionMessage = genericException.Message;
}
return(View("~/Views/Errors/Details.cshtml"));
}
public int FillAppointmentInfo(Appointment appointment, string description, List <Medicine> prescription, AppointmentEnumState state)
{
if (appointment != null)
{
string tempDescription;
if (string.IsNullOrEmpty(description.Trim()))
{
tempDescription = null;
}
else
{
tempDescription = description;
}
using (HospitalContext context = new HospitalContext())
{
using (DbContextTransaction transaction = context.Database.BeginTransaction())
{
try
{
appointment.Description = tempDescription;
appointment.State = state;
appointment.UpdateTime = DateTime.Now;
context.Entry(appointment).State = EntityState.Modified;
int result = context.SaveChanges();
var tempAppointment = context.Appointments.Include("Medicines").Single(I => I.Id == appointment.Id);
foreach (var item in prescription)
{
var tempMedicine = context.Medicines.Single(I => I.Id == item.Id);
tempAppointment.Medicines.Add(tempMedicine);
}
context.SaveChanges();
transaction.Commit();
return(1);
}
catch (Exception)
{
transaction.Rollback();
return(0);
}
}
}
}
else
{
return(-1);
}
}
public ActionResult Create([Bind(Include = "Id,Name,Status,DayOfBirth,TaxCode,Doctor")] Patient patient)
{
if (ModelState.IsValid)
{
db.Patients.Add(patient);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//DoctorsDropDownList(patient.Doctors);
ViewBag.DoctorsList = from d in db.Doctors
orderby d.Name
select d;
return(View(patient));
}
public ActionResult Create([Bind(Include = "Id,Title,Type,Time,Regularity,Desc,Status,Contact_person,Contact_phone")] Task task)
{
if (ModelState.IsValid)
{
task.Created_by = 1;
task.Modified_by = 1;
task.Created_date = DateTime.Now;
task.Modified_date = DateTime.Now;
db.Tasks.Add(task);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View("Admin/Create", task));
}
public static bool AddDoctor(HospitalContext dbContext)
{
Console.Clear();
Console.Write("Enter name: ");
string doctorName = Console.ReadLine();
Console.Write("Enter specialty: ");
string specialty = Console.ReadLine();
Console.Write("Enter E-Mail Address: ");
string emailAddress = Console.ReadLine();
Console.Write("Enter Password: ");
string password = EncryptionHelper.Encrypt(Console.ReadLine());
if (PatientDataValidation.IsEmailAddressValid(emailAddress))
{
dbContext.Add(new Doctor
{
DoctorName = doctorName,
Specialty = specialty,
EmailAddress = emailAddress,
Password = password
});
dbContext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public ActionResult Registration(AccountRegistrationVM vm)
{
try
{
if (ModelState.IsValid)
{
User u = context.Users.Single(q => q.Id == vm.UserId);
Patient p = context.Patients.Single(q => q.UserId == vm.UserId);
// hash password
u.Password = Hasher.ToHashedStr(vm.Password);
// replace the email token used for generating the link to new token
// String.Empty does not work because the column must be unique
p.EmailToken = TokenGenerator.GenerateEmailToken();
context.SaveChanges();
}
return(View("RegistrationComplete"));
}
catch (Exception e)
{
ViewBag.ExceptionMessage = e.Message;
}
return(View("~/Views/Errors/Details.cshtml"));
}
public ActionResult Test(FormCollection collection)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Login"));
}
else
{
string doctorName = collection["DoctorName"];
string patientName = Session["Username"].ToString();
string date = collection["Date"].ToString();
string time = collection["Time"].ToString();
//time = time.Insert(6, ":00");
//DateTime dt = DateTime.ParseExact("08/04/2019 08:00 PM", "dd/MM/yyyy hh:mm tt", CultureInfo.InvariantCulture);
DateTime dt = DateTime.ParseExact(date + " " + time, "dd/MM/yyyy hh:mm tt", CultureInfo.InvariantCulture);
Response.Write(date);
Response.Write(time);
//DateTime dt = DateTime.ParseExact(date+time, "MM/dd/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);
HospitalContext hc = new HospitalContext();
Doctor d = hc.Doctors.Single(u => u.DoctorName == doctorName);
Appointment b = hc.Appointments.OrderByDescending(x => x.AppointmentId).First();
int k = b.AppointmentId + 1;
Appointment a = new Appointment
{
DoctorId = d.DoctorId,
PatientId = Int32.Parse(Session["UserId"].ToString()),
Date = dt,
};
hc.Appointments.Add(a);
hc.SaveChanges();
return(RedirectToAction("AppointmentList"));
}
}
public ActionResult Cadastrar(Medico medico)
{
_context.Medicos.Add(medico);
_context.SaveChanges();
TempData["msg"] = "Médico registrado!";
return(RedirectToAction("Cadastrar"));
}
//Delete patient from system
public void DeletePatient(HospitalContext context)
{
Console.WriteLine("Write patient first name and last name:");
List <string> names = Console.ReadLine()
.Split(" ")
.ToList();
string patientFirstname = names[0];
string patientLastname = names[1];
var patientToDelete = context.Patients
.Where(p => p.FirstName == patientFirstname && p.LastName == patientLastname)
.FirstOrDefault();
if (context.Patients.Any(p => p == patientToDelete))
{
context.Patients.Remove(patientToDelete);
Console.WriteLine($"{patientToDelete.FirstName} {patientToDelete.LastName} deleted!");
}
else
{
throw new ArgumentNullException("There is no such patient in the system!");
}
context.SaveChanges();
}
public JsonResult ChangeApproval(int id, int value, int session, int docId, string date)
{
int serial = 0;
using (var ctx = new HospitalContext())
{
int amount = ctx.Appointment.Where(c => c.DoctorId == docId && c.Session == session &&
c.Date == date && c.Approval == 1).Select(c => c.Id).ToList().Count();
if (value == 1)
{
serial = amount + 1;
}
else
{
serial = 0;
}
Appointment a = ctx.Appointment.Single(c => c.Id == id);
a.Approval = value;
a.IsSeen = 2;
a.SerialNo = serial;
ctx.SaveChanges();
}
return(Json('1'));
}
public void Getqty()
{
var drugs = from d in _context.Drug
where d.Qty == 0
select d.Name;
var state = from d in _context.Drug
where d.Qty == 0
select d.State;
if (drugs != null)
{
foreach (string s in state)
{
if (s != "Not Available")
{
(from m in _context.Drug
where m.Qty == 0
select m).ToList().ForEach(n => n.State = "Not Available");
foreach (string name in drugs)
{
string to = "*****@*****.**"; //To address
string from = "*****@*****.**"; //From address
MailMessage message = new MailMessage(from, to);
string mailbody = name + " is out of stock";
message.Subject = "Some Drugs are out of stock ";
message.Body = mailbody;
//var filename = @"c:\test.pdf";
//message.Attachments.Add(new Attachment(filename));
message.BodyEncoding = System.Text.Encoding.UTF8;
message.IsBodyHtml = true;
SmtpClient client = new SmtpClient("smtp.gmail.com", 587); //Gmail smtp
System.Net.NetworkCredential basicCredential1 = new
System.Net.NetworkCredential("*****@*****.**", "tomcat123456");
client.EnableSsl = true;
client.UseDefaultCredentials = false;
client.Credentials = basicCredential1;
try
{
client.Send(message);
}
catch (Exception ex)
{
throw ex;
}
}
}
}
_context.SaveChanges();
}
}
public ActionResult DeleteConfirmed(int id)
{
feedback feedback = db.feedbacks.Find(id);
db.feedbacks.Remove(feedback);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void Main()
{
using (var db = new HospitalContext())
{
db.Database.Migrate();
db.SaveChanges();
}
}
public void Deletar(int id)
{
using (HospitalContext ctx = new HospitalContext())
{
ctx.Pacientes.Remove(ctx.Pacientes.Find(id));
ctx.SaveChanges();
}
}
public void Cadastrar(Doutores doutor)
{
using (HospitalContext ctx = new HospitalContext())
{
ctx.Doutores.Add(doutor);
ctx.SaveChanges();
}
}
public void Cadastrar(Pacientes paciente)
{
using (HospitalContext ctx = new HospitalContext())
{
ctx.Pacientes.Add(paciente);
ctx.SaveChanges();
}
}
public ActionResult Profile(string message)
{
ViewBag.PatientProfile = "active";
ViewBag.UpdateMessage = message;
int pid = (int)Session["PatientId"];
List <DoctorAppointmentView> ProfileList = new List <DoctorAppointmentView>();
Patient p = new Patient();
using (var ctx = new HospitalContext())
{
List <Appointment> lap = (from a in ctx.Appointment
where a.PatientId == pid && a.IsSeen == 2
select a).ToList();
foreach (Appointment q in lap)
{
q.IsSeen = 1;
}
ctx.SaveChanges();
Session["PatientNotify"] = 0;
var data = (from a in ctx.Appointment
join d in ctx.Doctor on a.DoctorId equals d.Id
where a.PatientId == pid
select new
{
aDate = a.Date,
aApproval = a.Approval,
aName = d.Name,
aPrescription = a.Prescription,
aDesignation = d.Designation,
aSerial = a.SerialNo
});
foreach (var d in data)
{
DoctorAppointmentView dc = new DoctorAppointmentView();
dc.Name = baseControl.Decrypt(d.aName);
dc.Designation = baseControl.Decrypt(d.aDesignation);
dc.Approval = d.aApproval;
dc.Date = d.aDate;
dc.Prescription = d.aPrescription;
dc.Serial = d.aSerial;
ProfileList.Add(dc);
}
// int id = Convert.ToInt32(Session["PatientId"]);
var k = ctx.Patient.Where(e => e.Id == pid).Select(c => new { c.Name, c.Age, c.Address, c.PhoneNo });
foreach (var i in k)
{
p.Name = baseControl.Decrypt(i.Name);
p.Address = baseControl.Decrypt(i.Address);
p.Age = i.Age;
p.PhoneNo = baseControl.Decrypt(i.PhoneNo);
}
ViewBag.Patient = p;
}
return(View(ProfileList));
}
public static void SeedPatients(HospitalContext context, int count)
{
for (int i = 0; i < count; i++)
{
context.Patients.Add(PatientGenerator.NewPatient(context));
}
context.SaveChanges();
}
public void createPaciente(Paciente Paciente)
{
Paciente tempPaciente = new Paciente();
tempPaciente.Nome = Paciente.Nome;
tempPaciente.Nascimento = Paciente.Nascimento;
tempPaciente.Telefone = Paciente.Telefone;
tempPaciente.CPF = Paciente.CPF;
tempPaciente.Convenio = Paciente.Convenio;
if (tempPaciente.Convenio != null)
{
ctx.Entry(tempPaciente.Convenio).State = System.Data.Entity.EntityState.Unchanged;
}
ctx.Pacientes.Add(tempPaciente);
ctx.SaveChanges();
}
public ActionResult Add(DoctorsWithPatients doctorsWithPatients)
{
var patient = db.Patients.Find(doctorsWithPatients.PatientName);
var doctor = db.Doctors.Find(doctorsWithPatients.DoctorName);
patient.Doctors.Add(doctor);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private static void SeedDoctors(HospitalContext context, int count)
{
for (int i = 0; i < count; i++)
{
context.Doctors.Add(DoctorsGenerator.NewDoctor(context));
}
context.SaveChanges();
}
public string AddPatient(Patient patient)
{
using (var ctx = new HospitalContext())
{
ctx.Patients.Add(patient);
ctx.SaveChanges();
}
return(patient.Pesel);
}