public HttpResponseMessage PostPatient(UyeBilgisi uye)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Patient Patient = db.tbl_Patient.FirstOrDefault(x => x.Tckn == uye.TcNo);
if (Patient != null)
{
if (Patient.PatientPassword == uye.Password)
{
return(Request.CreateResponse(HttpStatusCode.OK, Patient));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Yanlış şifre"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Put(tbl_Patient patient)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Patient Patient = db.tbl_Patient.FirstOrDefault(x => x.PatientID == patient.PatientID);
if (Patient != null)
{
Patient.PaitentMail = patient.PaitentMail;
Patient.PaitentName = patient.PaitentName;
Patient.PaitentSurname = patient.PaitentSurname;
Patient.PatientPassword = patient.PatientPassword;
if (db.SaveChanges() > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Güncellendi"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Güncelleme yapi1lamadi"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Put(tbl_HospitalManager manager)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_HospitalManager Manager = db.tbl_HospitalManager.FirstOrDefault(x => x.ManagerID == manager.ManagerID);
if (Manager != null)
{
Manager.ManagerName = manager.ManagerName;
Manager.ManagerPassword = manager.ManagerPassword;
Manager.ManagerSurname = manager.ManagerUserName;
if (db.SaveChanges() > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Güncellendi"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Güncelleme yapi1lamadi"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Put(tbl_Hospital hospital)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Hospital Hospital = db.tbl_Hospital.FirstOrDefault(x => x.HospitalID == hospital.HospitalID);
if (Hospital != null)
{
Hospital.HospitalName = hospital.HospitalName;
if (db.SaveChanges() > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Güncellendi"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Güncelleme yapi1lamadi"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public void GetMaas()
{
using (var db = new HastaneDBEntities())
{
db.MaasHesaplaa();
}
}
public HttpResponseMessage Put(tbl_Doctor doctor)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Doctor Doctor = db.tbl_Doctor.FirstOrDefault(x => x.DoctorID == doctor.DoctorID);
if (Doctor != null)
{
Doctor.DoctorName = doctor.DoctorName;
Doctor.DoctorSurname = doctor.DoctorSurname;
Doctor.DoctorPassword = doctor.DoctorPassword;
if (db.SaveChanges() > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Güncellendi"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Güncelleme yapi1lamadi"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Put(tbl_Department department)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Department Deparment = db.tbl_Department.FirstOrDefault(x => x.DepartmentID == department.DepartmentID);
if (Deparment != null)
{
Deparment.DepartmentName = department.DepartmentName;
if (db.SaveChanges() > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, "Güncellendi"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Güncelleme yapi1lamadi"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage DeleteDepartment(İd id)
{
try
{
using (var db = new HastaneDBEntities())
{
if (db.tbl_Department.FirstOrDefault(x => x.DepartmentID == id.id) != null)
{
db.tbl_Departmentss.Remove(db.tbl_Departmentss.FirstOrDefault(x => x.DepartmentID == id.id));
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "silindi"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Postmanagerial(UyeBilgisi uyee)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Doctor Doctor = new tbl_Doctor();
tbl_Admin Admin = new tbl_Admin();
tbl_HospitalManager Manager = new tbl_HospitalManager();
Doctor = db.tbl_Doctor.FirstOrDefault(x => x.Tckn == uyee.TcNo);
Admin = db.tbl_Admin.FirstOrDefault(x => x.Tckn == uyee.TcNo);
Manager = db.tbl_HospitalManager.FirstOrDefault(x => x.Tckn == uyee.TcNo);
if (Doctor != null)
{
if (Doctor.DoctorPassword == uyee.Password)
{
return(Request.CreateResponse(HttpStatusCode.OK, Doctor));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Yanlış şifre"));
}
}
if (Admin != null)
{
if (Admin.AdminPassword == uyee.Password)
{
return(Request.CreateResponse(HttpStatusCode.OK, Admin));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Yanlış şifre"));
}
}
if (Manager != null)
{
if (Manager.ManagerPassword == uyee.Password)
{
return(Request.CreateResponse(HttpStatusCode.OK, Manager));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Yanlış şifre"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "TcNo Hatalı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage PostDepart(Id id)
{
try
{
var db = new HastaneDBEntities();
return(Request.CreateResponse(HttpStatusCode.OK, db.DepartmenList(id.id).ToList()));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage GetHospital()
{
try
{
var db = new HastaneDBEntities();
return(Request.CreateResponse(HttpStatusCode.OK, db.HospitalList().ToList()));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage GetRandevu(Id id)
{
try
{
using (var db = new HastaneDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.favoriList(id.id).ToList()));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage PostAdminRandevu(rande ran)
{
try
{
using (var db = new HastaneDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.AdminAppointment(ran.Did, ran.date, ran.time)));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage DeleteRandevuDoctor(randevu ran)
{
try
{
using (var db = new HastaneDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.RemoveAppointmentDoctor(ran.id, ran.Did)));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Postdoctor(randevu rande)
{
try
{
using (var db = new HastaneDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.RandevuDoctor(rande.HID, rande.DID).ToList()));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage PostCancelDoctor(Id id)
{
try
{
using (var db = new HastaneDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.CanceledAppointmentDoctor(id.id).ToList()));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Postsaat(saat saat)
{
try
{
using (var db = new HastaneDBEntities())
{
return(Request.CreateResponse(HttpStatusCode.OK, db.Randevudate(saat.id, saat.date).ToList()));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage PostKullanıcı(Id id)
{
using (var db = new HastaneDBEntities())
{
try
{
tbl_Doctor Doctor = new tbl_Doctor();
tbl_Admin Admin = new tbl_Admin();
tbl_HospitalManager Manager = new tbl_HospitalManager();
tbl_Patient Patient = new tbl_Patient();
Patient = db.tbl_Patient.FirstOrDefault(x => x.PatientID == id.id);
Doctor = db.tbl_Doctor.FirstOrDefault(x => x.DoctorID == id.id);
Admin = db.tbl_Admin.FirstOrDefault(x => x.AdminID == id.id);
Manager = db.tbl_HospitalManager.FirstOrDefault(x => x.ManagerID == id.id);
if (Patient != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, Patient));
}
if (Doctor != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, Doctor));
}
if (Admin != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, Admin));
}
if (Manager != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, Manager));
}
else
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, "Id kullanılmamakta"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
}
public HttpResponseMessage Delete(tbl_Favorite favori)
{
try
{
using (var db = new HastaneDBEntities())
{
if (db.tbl_Favorite.FirstOrDefault(x => x.DoctorID == favori.DoctorID || x.PatientID == favori.PatientID) != null)
{
db.tbl_Favorite.Remove(favori);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "silindi"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bulunamadı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Post(tbl_Department departman)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Department Departman = db.tbl_Department.FirstOrDefault(x => x.DepartmentName == departman.DepartmentName);
if (Departman != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bu departman bulunmakta"));
}
else
{
db.tbl_Department.Add(departman);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, departman));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Post(tbl_HospitalManager manager)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_HospitalManager Manager = db.tbl_HospitalManager.FirstOrDefault(x => x.Tckn == manager.Tckn);
if (Manager != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bu Tc kullanılmakta"));
}
else
{
db.tbl_HospitalManager.Add(manager);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, manager));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Post(tbl_Favorite favori)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Favorite Favori = db.tbl_Favorite.FirstOrDefault(x => x.DoctorID == favori.DoctorID && x.PatientID == favori.PatientID);
if (Favori != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bu hastanede bu departman bulunmakta bulunmakta"));
}
else
{
db.addFavoriteDoctor(favori.PatientID, favori.DoctorID);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, favori));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage HastaPost(tbl_Patient patient)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Patient Patient = db.tbl_Patient.FirstOrDefault(x => x.Tckn == patient.Tckn);
if (Patient != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Bu Tc kullanılmakta"));
}
else
{
db.tbl_Patient.Add(patient);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, patient));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Post(tbl_Departmentss departmens)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Departmentss Departmens = db.tbl_Departmentss.FirstOrDefault(x => x.HospitalID == departmens.HospitalID || x.DepartmentID == departmens.DepartmentID);
if (Departmens != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bu hastanede bu departman bulunmakta bulunmakta"));
}
else
{
db.tbl_Departmentss.Add(departmens);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, departmens));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public HttpResponseMessage Post(tbl_Hospital hospital)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Hospital Hospital = db.tbl_Hospital.FirstOrDefault(x => x.HospitalName == hospital.HospitalName);
if (db.tbl_Hospital.FirstOrDefault(x => x.HospitalName == hospital.HospitalName) != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bu hastane bulunmakta"));
}
else
{
db.tbl_Hospital.Add(hospital);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, hospital));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
