public async Task <IHttpActionResult> PutVISIT(int id, VISIT vISIT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != vISIT.Visit_ID)
{
return(BadRequest());
}
db.Entry(vISIT).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VISITExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public PatientRegistrationDTO()
{
MESSAGE_HEADER = new MESSAGEHEADER();
PATIENT_IDENTIFICATION = new PATIENTIDENTIFICATION();
NEXT_OF_KIN = new List <NEXTOFKIN>();
PATIENT_VISIT = new VISIT();
}
private void LoadFeautureVisits(int id)
{
SqlConnection connection = new SqlConnection(MyProject.Properties.Settings.Default.Connection);
try
{
connection.Open();
}
finally
{
string select1 = $"select * FROM DOCTOR INNER JOIN (SELECT * FROM VISIT INNER JOIN PACIENT ON VISIT.IDPACIENT=PACIENT.PACIENTID WHERE PACIENT.PACIENTID={id} AND VISIT.DATE > CONVERT (date, SYSDATETIME())) VISITS ON VISITS.IDDOCTOR=DOCTOR.DOCTORID";
SqlCommand command = new SqlCommand(select1, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
User FutureVisits = new User();
FutureVisits.DocName = reader.GetString(2);
FutureVisits.DateVisit = reader.GetDateTime(9);
FutureVisits.TimeVisit = reader.GetTimeSpan(10);
FutureVisits.Room = reader.GetInt32(5);
VISIT.Add(FutureVisits);
}
connection.Close();
if (VISIT.Count > 0)
{
FutureVisits = VISIT[0];
}
}
}
}
private void Button_Click_Ok(object sender, RoutedEventArgs e)
{
//if (string.IsNullOrEmpty(comboBox1.Text))
if (ComboBoxDoctor.SelectedItem != null && ComboBoxPatient.SelectedItem != null && cldSample.SelectedDate != null)
{
if (AddEditVisitLabel.Text == "Create Visit")
{
visitToEdit = new VISIT
{
DOCTOR1 = (DOCTOR)ComboBoxDoctor.SelectedItem,
PATIENT1 = (PATIENT)ComboBoxPatient.SelectedItem,
DATEOFVISIT = cldSample.SelectedDate.Value
};
main_.AddFinished(visitToEdit);
this.Close();
}
else if (AddEditVisitLabel.Text == "Edit Visit")
{
visitToEdit.DOCTOR1 = (DOCTOR)ComboBoxDoctor.SelectedItem;
visitToEdit.PATIENT1 = (PATIENT)ComboBoxPatient.SelectedItem;
visitToEdit.DATEOFVISIT = cldSample.SelectedDate.Value;
main_.EditFinished(visitToEdit);
this.Close();
}
}
else
{
MessageBox.Show("Error. Choose all the properties for the visit");
}
}
//向数据库中加入用户访问视频的记录
//向数据库中加入用户访问视频的记录
public void AddVisit(string user_id, string video_id)
{
VISIT vISIT = new VISIT();
vISIT.VIDEO_ID = video_id;
vISIT.USER_ID = user_id;
vISIT.VISIT_TIME = DateTime.Now;
db.VISIT.Add(vISIT);
db.SaveChanges();
}
public async Task <IHttpActionResult> GetVISIT(int id)
{
VISIT vISIT = await db.VISITs.FindAsync(id);
if (vISIT == null)
{
return(NotFound());
}
return(Ok(vISIT));
}
public async Task <IHttpActionResult> PostVISIT(VISIT vISIT)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.VISITs.Add(vISIT);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = vISIT.Visit_ID }, vISIT));
}
public void updateVisit(VISIT toEdit, VISIT newvisit)
{
VISIT query = (from visit in context.VISITs
where visit.IDV == toEdit.IDV
select visit).First();
query.DOCTOR1 = newvisit.DOCTOR1;
query.PATIENT1 = newvisit.PATIENT1;
query.DATEOFVISIT = newvisit.DATEOFVISIT;
context.SaveChanges();
}
public async Task <IHttpActionResult> DeleteVISIT(int id)
{
VISIT vISIT = await db.VISITs.FindAsync(id);
if (vISIT == null)
{
return(NotFound());
}
db.VISITs.Remove(vISIT);
await db.SaveChangesAsync();
return(Ok(vISIT));
}
public AddEditVisit(IAddEditVisitParent main, IEnumerable <PATIENT> pats, IEnumerable <DOCTOR> docs, VISIT visit)
{
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
InitializeComponent();
AddEditVisitLabel.Text = "Edit Visit";
main_ = main;
ComboBoxDoctor.ItemsSource = docs;
ComboBoxPatient.ItemsSource = pats;
visitToEdit = visit;
ComboBoxPatient.IsEnabled = false;
ComboBoxPatient.SelectedItem = visit.PATIENT1;
ComboBoxDoctor.SelectedItem = visit.DOCTOR1;
cldSample.SelectedDate = visit.DATEOFVISIT;
}
private void LoadVisits(int id)
{
SqlConnection connection = new SqlConnection(MyProject.Properties.Settings.Default.Connection);
try
{
connection.Open();
}
finally
{
string select1 = $"select * FROM PACIENT INNER JOIN (SELECT * FROM VISIT INNER JOIN DOCTOR ON VISIT.IDDOCTOR=DOCTOR.DOCTORID WHERE DOCTOR.DOCTORID={id} AND VISIT.DATE >= CONVERT (date, SYSDATETIME()) ) VISITS ON VISITS.IDPACIENT=PACIENT.PACIENTID";
SqlCommand command = new SqlCommand(select1, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Doctor doctor = new Doctor();
doctor.IdVisit = reader.GetInt32(8);
doctor.PacientName = reader.GetString(3);
doctor.Surname = reader.GetString(4);
doctor.DataVisit = reader.GetDateTime(11);
doctor.TimeVisit = reader.GetTimeSpan(12);
if (!reader.IsDBNull(13))
{
doctor.Diagnose = reader.GetString(13);
}
if (!reader.IsDBNull(14))
{
doctor.Treatment = reader.GetString(14);
}
VISIT.Add(doctor);
}
}
connection.Close();
}
}
public void deleteVisit(VISIT visitToDel)
{
context.VISITs.Remove(visitToDel);
context.SaveChanges();
}
public void insertVisit(VISIT v)
{
context.VISITs.Add(v);
context.SaveChanges();
}
