public ActionResult CreateNaprav(Naprav naprav)
{
bool Status = false;
string message = "";
if (ModelState.IsValid)
{
using (ClinicModel dc = new ClinicModel())
{
var e = dc.Pacients.Where(a => a.ID_Pacinents == naprav.ID_Pacients).FirstOrDefault();
var p = dc.Procedure.Where(a => a.ID_Procedure == naprav.ID_Procedure).FirstOrDefault();
if (e == null)
{
ModelState.AddModelError("donapExist", "Введені не існуючі дані");
return(View(naprav));
}
else if (p == null)
{
ModelState.AddModelError("donappExist", "Введені не існуючі дані");
return(View(naprav));
}
}
}
else
{
message = "Невірний запит";
}
ViewBag.Message = message;
ViewBag.Status = Status;
db.Entry(naprav).State = EntityState.Added;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult CreateEquip(Equipments equipments)
{
bool Status = false;
string message = "";
if (!ModelState.IsValid)
{
message = "Невірний запит";
}
ViewBag.Message = message;
ViewBag.Status = Status;
db.Entry(equipments).State = EntityState.Added;
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void btnSave_Click(object sender, EventArgs e)
{
Clinic clinic = new Clinic()
{
Identifier = int.Parse(txtClinicNumber.Text),
Title = (Title)Enum.Parse(typeof(Title), cboTitle.Text),
LastName = txtLastName.Text,
FirstName = txtFirstName.Text,
Specialty = txtSpecialty.Text,
Department = txtDepartment.Text,
Address = txtAddress.Text,
Telephone = txtTelephone.Text,
Email = txtEmail.Text,
CreatedAt = DateTime.Now
};
using (ClinicModel context = new ClinicModel())
{
context.Clinicians.Add(clinic);
context.SaveChanges();
}
MessageBox.Show("Clinic Saved");
Close();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
txtDateAmend.Text = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
var patient = new Patient()
{
Identifier = int.Parse(txtPid.Text),
HospitalNumber = int.Parse(txtHospNum.Text),
Title = (Title)Enum.Parse(typeof(Title), cmbtitle.Text),
LastName = txtLname.Text,
FirstName = txtFname.Text,
MiddleName = txtMname.Text,
Gender = (Gender)Enum.Parse(typeof(Gender), cmbGender.Text),
BirthDate = DateTime.Parse(txtDob.Text),
Phone = int.Parse(txtPhone.Text),
MobilePhone = int.Parse(txtMPhone.Text),
Email = txtEmail.Text,
HomeAddress = txtHAddress.Text,
City = txtCity.Text,
State = txtState.Text,
MaritalStatus = (MaritalStatus)Enum.Parse(typeof(MaritalStatus), cmbMStatus.Text),
PatientConsultant = txtPatConsultant.Text,
Nationality = txtNat.Text,
StateOfOrigin = txtSOrigin.Text,
Hometown = txtTOrigin.Text,
PlaceOfBirth = txtPoB.Text,
Religion = txtReligion.Text,
Occupation = txtOccupation.Text,
OfficeAddress = txtOAddress.Text,
NationalIdType = cmbNIDType.Text,
NationalIdNumber = txtNidNumber.Text,
NextOfKin = txtNok.Text,
AddressNextOfKin = txtNoKAddress.Text,
PhoneNextOfKin = int.Parse(txtNoKPhone.Text),
EmailNextOfKin = txtNoKEmail.Text,
NextOfKinRelationship = cmbNokRelationship.Text,
NameOfFather = txtFather.Text,
NameOfMother = txtMother.Text,
HealthInsuranceProvider = txtHealthIns.Text,
AddressHealthInsuranceProvider = txtHealthAddr.Text,
PhoneHealthInsuranceProvider = int.Parse(txtHealthPhone.Text),
EmailHealthInsuranceProvider = txtHealthEmail.Text,
DateAmended = txtDateAmend.Text,
Photo = GetBytesFromImage()
};
using (ClinicModel context = new ClinicModel())
{
context.Patients.Add(patient);
context.SaveChanges();
}
GetBytesFromImage();
MessageBox.Show("Patient Record Updated");
}
private void btnSave_Click(object sender, EventArgs e)
{
User user = new User()
{
FirstName = txtFName.Text,
LastName = txtLName.Text,
Username = txtUsername.Text,
Password = txtPassword.Text,
ModuleAccess = txtProfile.Text
};
using (ClinicModel context = new ClinicModel())
{
context.Users.Add(user);
context.SaveChanges();
}
MessageBox.Show("New User Created");
Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
var ap = new Appointment()
{
Identifier = int.Parse(txtCNum.Text),
ClinicianName = txtPatConsultant.Text,
PatientId = int.Parse(txtPid.Text),
HospitalNumber = int.Parse(txtHospNum.Text),
PatientName = txtPatname.Text,
Created = dateTimePicker1.Value,
Purpose = txtApptPurpose.Text,
CreatedAt = DateTime.Now
};
using (ClinicModel context = new ClinicModel())
{
context.Appointments.Add(ap);
context.SaveChanges();
}
MessageBox.Show("Clinic Saved");
}
public void AddNewTitle()
{
TitleTable tbl = new TitleTable
{
Abbreviation = "MR",
Description = "Mister"
};
TitleTable retriviedTbl;
using (var context = new ClinicModel(null))
{
context.Titles.Add(tbl);
context.SaveChanges();
retriviedTbl = context.Titles
.Single(x => x.Abbreviation == "MR");
}
Assert.IsNotNull(retriviedTbl);
Assert.AreEqual(1, retriviedTbl.Identifier);
Assert.AreEqual(tbl.Abbreviation, retriviedTbl.Abbreviation);
Assert.AreEqual(tbl.Description, retriviedTbl.Description);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtPassConfirm.Text == txtPassword.Text)
{
_user.Password = txtPassword.Text;
using (ClinicModel context = new ClinicModel())
{
context.Users.Attach(_user);
context.SaveChanges();
}
MessageBox.Show("Password changed successfully");
Close();
}
else
{
MessageBox.Show("Please confirm Password and Confirm Pasword fields match");
txtPassword.Text = "";
txtPassConfirm.Text = "";
}
}
public void Save()
{
_context.SaveChanges();
}
