public bool VerifyAppointment(int verifyUserID, string verifyUserPassword, int nAppointmentID)
{
TblEmployee verifyUser = new TblEmployee();
verifyUser.NEmployeeID = verifyUserID;
verifyUser.SelectOne();
if (verifyUser.StrPassword.IsNull)
{
throw new Exception("Invalid User ID or Password");
}
if (verifyUser.StrPassword.Value != verifyUserPassword)
{
throw new Exception("Invalid User ID or Password");
}
TblAppointment myAppointment = new TblAppointment();
myAppointment.NAppointmentId = nAppointmentID;
myAppointment.SelectOne();
if (!myAppointment.NVerifiedBy.IsNull)
{
throw new Exception("This appointment have been verified by other staff with the employee ID : " + myAppointment.NVerifiedBy.Value.ToString());
}
myAppointment.NVerifiedBy = verifyUserID;
//myAppointment.NStatus = 1;
myAppointment.Update();
return(true);
}
public async Task <string> CreateNewAppointment(AppointmentDTO appointment)
{
using (var dbcxtransaction = _tandVardContext.Database.BeginTransaction())
{
var tblInsertItem = new TblAppointment()
{
FldAppointmentBegin = appointment.FldAppointmentBegin,
FldAppointmentEnd = appointment.FldAppointmentEnd,
FldDenistIdFK = appointment.FldDenistIdFK,
FldPatientFK = appointment.FldPatientFK
};
if (!_tandVardContext.TblUsers.Any(x => x.FldUserId == tblInsertItem.FldDenistIdFK))
{
throw new ArgumentException("The appointed dentist does not Exist");
}
if (!_tandVardContext.TblPatients.Any(x => x.FldPatientId == tblInsertItem.FldPatientFK))
{
throw new ArgumentException("The appointed patient does not Exist");
}
var result = await _tandVardContext.TblAppointments.AddAsync(tblInsertItem);
if (result.State.ToString() != "Added")
{
throw new Exception("Appointment was not added");
}
_tandVardContext.SaveChanges();
dbcxtransaction.Commit();
return("Appointment was successfully created");
}
}
public bool VerifyAppointmentLimit(int nContactID)
{
TblAppointment appt = new TblAppointment();
DataTable table = appt.LoadData("Select COUNT (*) as nCount From TblAppointment where nContactID = @nContactID group by strReceiptNo", new string[] { "@nContactID" }, new object[] { nContactID });
decimal netTotal = 0;
if (table.Rows.Count > 0)
{
netTotal = ACMS.Convert.ToDecimal(table.Rows[0]["mSubTotal"]);
}
return(true);
}
public bool CloseAppointment(int nAppointmentID)
{
TblAppointment myAppointment = new TblAppointment();
myAppointment.NAppointmentId = nAppointmentID;
myAppointment.SelectOne();
myAppointment.NStatus = 2;
myAppointment.Update();
TblContacts myContact = new TblContacts();
myContact.UpdateLeadStatus(Convert.ToInt32(myAppointment.NContactId.Value), 0);
return(true);
}
public void Post([FromBody] TblAppointment value)
{
bool appointmentClash = ValidateNoAppoinmentClash(value);
if (appointmentClash == true)
{
db.TblPatients.Add(value.AppointmentPatient);
db.TblAppointments.Add(value);
db.SaveChanges();
}
else
{
throw new Exception("Seçtiğiniz tarih aralığında doktorumuz müsait değildir.");
}
}
private bool ValidateNoAppoinmentClash(TblAppointment newAppointment)
{
var appointments = from a in db.TblAppointments.Where(x => x.AppointmentDoctorId == newAppointment.AppointmentDoctorId)
select a;
foreach (var item in appointments)
{
if (newAppointment.AppointmentStartDate > item.AppointmentStartDate && newAppointment.AppointmentStartDate < item.AppointmentEndDate ||
newAppointment.AppointmentEndDate > item.AppointmentStartDate && newAppointment.AppointmentEndDate < item.AppointmentEndDate)
{
return(false);
}
}
return(true);
}
public void Put(string id, [FromBody] TblAppointment appointment)
{
ms.Database.ExecuteSqlCommand("updateAppointmentStatus '" + id + "'," + appointment.ApStatus);
}
public void Post([FromBody] TblAppointment appointment)
{
msc.Database.ExecuteSqlCommand("exec bookingAppointment '" + appointment.ApDrUserId + "','" + appointment.ApMdMedicareServiceId + "','" + appointment.ApPtUserId + "','" + appointment.ApDate + "','" + appointment.ApTime + "'");
}
public void Put([FromBody] TblAppointment appointmentUpdate)
{
ms.Database.ExecuteSqlCommand("updateAppointment '" + appointmentUpdate.ApAppointmentId + "','" + appointmentUpdate.ApDrUserId +
"','" + appointmentUpdate.ApMdMedicareServiceId + "','" + appointmentUpdate.ApPtUserId + "','" + appointmentUpdate.ApDate +
"','" + appointmentUpdate.ApTime + "'");
}
public void Post([FromBody] TblAppointment appointment)
{
ms.Database.ExecuteSqlCommand("insertAppointment '" + appointment.ApDrUserId + "','" + appointment.ApMdMedicareServiceId +
"','" + appointment.ApPtUserId + "','" + appointment.ApDate + "','" + appointment.ApTime + "'," + appointment.ApStatus);
}
