public async Task <bool> UpdateBooking(PatientBooking booking)
{
ReplaceOneResult updateresult = await _context
.BookingsCollection
.ReplaceOneAsync(
filter : b => b.BookingID == booking.BookingID,
replacement : booking);
return(updateresult.IsAcknowledged && updateresult.ModifiedCount > 0);
}
public async Task MakeBooking(PatientBooking booking)
{
try
{
await _context.BookingsCollection.InsertOneAsync(booking);
}
catch (Exception ex)
{
// log or manage the exception
throw ex;
}
}
public ActionResult RecordSerial(SerialBookingModel objSerialBookingModel)
{
if (ModelState.IsValid)
{
var doctorId = _db.Doctors.First(m => m.DoctorName.Equals(objSerialBookingModel.Doctor)).DoctorId;
var checkIsNotNull = _db.PatientBookings.Any(
m => m.HospitalId.Equals(objSerialBookingModel.HospitalId) && m.DoctorId.Equals(doctorId));
int serial = 0;
if (checkIsNotNull)
{
serial =
_db.PatientBookings.Where(
m => m.HospitalId.Equals(objSerialBookingModel.HospitalId) && m.DoctorId.Equals(doctorId))
.Max(m => m.SerialNo);
}
var objDoctor = new PatientBooking
{
PatientName = objSerialBookingModel.PatientName,
PatientAge = objSerialBookingModel.PatientAge,
DoctorId = doctorId,
Gender = objSerialBookingModel.Gender,
MaritalStatus = objSerialBookingModel.MaritalStatus,
PatientType = objSerialBookingModel.PatientType,
BookingDateTime = DateTime.Now,
VisitDate = objSerialBookingModel.VisitDate,
HospitalId = objSerialBookingModel.HospitalId, SerialNo = (serial + 1)
};
_db.PatientBookings.Add(objDoctor);
_db.SaveChanges();
ModelState.Clear();
ViewBag.successVal = 1;
}
DisplayHospitalSelectlist();
DisplayDoctorSelectlist();
return(View());
}
public async Task <IActionResult> Post([FromBody] PatientBooking appointment)
{
await _bookingRepository.MakeBooking(appointment);
return(new OkObjectResult(appointment));
}
public IHttpActionResult SavePatientBooking(PatientBookingModel model)
{
try
{
var UserId = ((ClaimsIdentity)User.Identity).Claims.FirstOrDefault(c => c.Type.Equals(ClaimTypes.NameIdentifier)).Value;
var RefType = ((ClaimsIdentity)User.Identity).Claims.FirstOrDefault(c => c.Type.Equals(ClaimTypes.Name)).Value;
var RefID = ((ClaimsIdentity)User.Identity).Claims.FirstOrDefault(c => c.Type.Equals(ClaimTypes.Sid)).Value;
if (RefType == "1")
{
model.TherapistID = Convert.ToInt32(RefID);
}
else if (RefType == "2")
{
model.PatientID = Convert.ToInt32(RefID);
}
if (model.PatientBookingID == 0)
{
PatientBooking pb = new PatientBooking();
pb.ServiceID = model.ServiceID;
pb.Address = model.Address;
pb.BookingDate = model.BookingDate;
pb.FromTime = model.FromTime;
pb.ToTime = model.ToTime;
pb.PatientID = model.PatientID;
pb.TherapistID = model.TherapistID;
pb.Status = "PENDING";
entities.PatientBookings.Add(pb);
}
else
{
var getBooking = entities.PatientBookings.Where(x => x.PatientBookingID == model.PatientBookingID).FirstOrDefault();
getBooking.ServiceID = model.ServiceID;
getBooking.Address = model.Address;
getBooking.BookingDate = model.BookingDate;
getBooking.FromTime = model.FromTime;
getBooking.ToTime = model.ToTime;
}
entities.SaveChanges();
if (model.PatientBookingID == 0)
{
SendMail mail = new SendMail();
RegisterDL obj1 = new RegisterDL();
var list = obj1.GetUserDetails(Convert.ToInt32(UserId), Convert.ToInt32(RefType));
// var getAllService = obj1.GetAllServices();
string getServiceName = entities.Services.Where(x => x.ServiceID == model.ServiceID).Select(x => x.ServiceName).FirstOrDefault();
//foreach (var item in model.BookingSerList)
//{
// getServiceName += getAllService.Where(x => x.ServiceID == item.ServiceID).FirstOrDefault().ServiceName + ",";
//}
//getServiceName = getServiceName.TrimEnd(',');
string body = mail.createEmailBody("PatientBooking.html");
body = body.Replace("{UserName}", list[0].FirstName + " " + list[0].LastName);
body = body.Replace("{servicename}", getServiceName);
body = body.Replace("{address}", model.Address);
mail.SendGeneralMail("Patient Booking", list[0].Email, body);
}
//int bookId = Convert.ToInt32(RefID);
//int BookingID = entities.Bookings.Where(x => x.PatientID == bookId).Select(x => x.BookingID).FirstOrDefault();
responseData.message = "Booking details saved successfully";
responseData.success = true;
//responseData.data = BookingID;
return(Ok(responseData));
}
catch (Exception ex)
{
responseData.message = ex.Message != null?ex.Message.ToString() : "server error";
responseData.success = false;
return(Ok(responseData));
}
}
