public void BookAppointmentTest()
{
List <string> actual = new List <string>();
BookAppointment book = new BookAppointment("DoctorA", "patient", "12/10/2015", "09:00:00");
IDBConnect dbConnector = new dbCommTEST();
book.setDBConnectInstance(dbConnector);
actual = book.execute();
List <string> expected = new List <string>();
expected.Add("07");
expected.Add("1");
Assert.AreEqual(expected[0], actual[0]);
Assert.AreEqual(expected[1], actual[1]);
}
public void CreateAppointment(BookAppointment objAppointment)
{
try
{
using (var conn = OpenConnection())
{
conn.Execute("CALL public.usp_createappointment(@PatientId,@DoctorId,@AppointmentTime,@Status)",
new { PatientId = objAppointment.PatientId, DoctorId = objAppointment.DoctorId, AppointmentTime = objAppointment.AppointmentTime, Status = "Booked" }, null, null);
}
}
catch (Exception ex)
{
throw;
}
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
BookAppointment = await _context.BookAppointments.FirstOrDefaultAsync(m => m.BookAppointmentID == id);
if (BookAppointment == null)
{
return(NotFound());
}
return(Page());
}
public IActionResult UpdateBookAppointmentForBarber(int id, [FromBody] BookAppointmentForUpdateData data)
{
var claimsPrincipal = User as ClaimsPrincipal;
int barberId = int.Parse(claimsPrincipal.FindFirst("userId").Value);
BookAppointment bookAppointment = BookAppointmentDataStore.Current.Appointments.FirstOrDefault(ba => ba.Id == id && ba.BarberId == barberId);
if (bookAppointment == null)
{
return(NotFound());
}
bookAppointment.Cancel = data.Cancel;
bookAppointment.Hour = data.Hour;
return(NoContent());
}
public BookAppointment Create(CreateBookAppointment inputBookApointment)
{
BookAppointment newBookAppointment = new BookAppointment()
{
Id = 99,
BarberId = inputBookApointment.BarberId,
Cancel = 0,
ClientId = 1,
Date = inputBookApointment.Date,
Hour = inputBookApointment.Hour
};
_bookappointments.Add(newBookAppointment);
return(newBookAppointment);
}
public ActionResult AppointmentForm(BookAppointment bookAppointment, FormCollection formData)
{
if (!ModelState.IsValid)
{
ViewBag.ValidationMessage = "Please update the highlighted mandatory field(s)";
return(View());
}
else
{
DBContext bookappointment = new DBContext();
bookappointment.BookAppointments.Add(bookAppointment);
bookappointment.SaveChanges();
ViewBag.ValidationMessage = "Your details are submitted succesfully.";
return(View());
}
}
public IActionResult DeleteBookAppointment(int id)
{
var claimsPrincipal = User as ClaimsPrincipal;
var role = claimsPrincipal.FindFirst("role").Value;
if (!role.Equals("client"))
{
BookAppointment bookAppointment = BookAppointmentDataStore.Current.Appointments.FirstOrDefault(ba => ba.Id == id);
if (bookAppointment == null)
{
return(NotFound());
}
BookAppointmentDataStore.Current.Appointments.Remove(bookAppointment);
return(NoContent());
}
return(Unauthorized());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
BookAppointment = await _context.BookAppointments.FindAsync(id);
if (BookAppointment != null)
{
_context.BookAppointments.Remove(BookAppointment);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> Update([FromBody] BookAppointment model)
{
if (ModelState.IsValid)
{
try
{
var data = await I_BookAppointment.Update(model);
return(Ok(data));
}
catch (Exception)
{
return(BadRequest());
}
}
return(BadRequest("ModelState is Invalid"));
}
public async Task<IActionResult> OnGetAsync(int? id)
{
if (id == null)
{
return NotFound();
}
BookAppointment = await _context.BookAppointments
.Include(s => s.Patient)
.AsNoTracking()
.FirstOrDefaultAsync(m => m.BookAppointmentID == id);
if (BookAppointment == null)
{
return NotFound();
}
return Page();
}
public string AddAppointment(BookAppointment appointment)
{
try
{
DateTime obj = DateTime.Parse(appointment.Start);
appointment.Start = obj.ToString("yyyy-MM-dd T HH:mm:ss");
appointment.End = obj.AddMinutes(appointment.EndMinute).ToString("yyyy-MM-dd T HH:mm:ss");
var StartTime = DateTime.Parse(appointment.StartHour, CultureInfo.InvariantCulture);
var Time = StartTime.ToString("HH:mm").Split(':');
appointment.StartHour = Time[0];
appointment.StartMinute = Time[1];
string apiURL = ConfigurationManager.AppSettings["DomainUrl"].ToString() + "/api/booking/BookAppointment";
string result = "";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(apiURL);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
httpWebRequest.ProtocolVersion = HttpVersion.Version10;
httpWebRequest.Headers.Add("Token", Request.Headers["Token"]);
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
var jsonString = new JavaScriptSerializer().Serialize(appointment);
streamWriter.Write(jsonString);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
result = streamReader.ReadToEnd();
}
return(result);
}
catch (Exception e)
{
return(e.ToString());
}
}
public IActionResult CreateBookAppointment([FromBody] BookAppointmentClientForCreateData data)
{
var claimsPrincipal = User as ClaimsPrincipal;
int clientId = int.Parse(claimsPrincipal.FindFirst("userId").Value);
var role = claimsPrincipal.FindFirst("role").Value;
var maxBookAppointmentId = BookAppointmentDataStore.Current.Appointments.Max(ba => ba.Id);
var newBookAppointment = new BookAppointment()
{
Id = ++maxBookAppointmentId,
Cancel = 0,
Hour = data.Hour,
Date = data.Date,
ClientId = clientId,
BarberId = data.BarberId // TODO: this should be fetched from database
};
BookAppointmentDataStore.Current.Appointments.Add(newBookAppointment);
return(CreatedAtRoute("GetBookAppointmentsById", new { newBookAppointment.Id }, newBookAppointment));
}
public IActionResult CreateBookAppointmentForBarber(int clientId, [FromBody] BookAppointmentBarberForCreateData data)
{
var claimsPrincipal = User as ClaimsPrincipal;
int barberId = int.Parse(claimsPrincipal.FindFirst("userId").Value);
var role = claimsPrincipal.FindFirst("role").Value;
var maxBookAppointmentId = BookAppointmentDataStore.Current.Appointments.Max(ba => ba.Id);
var newBookAppointment = new BookAppointment()
{
Id = ++maxBookAppointmentId,
Cancel = 0,
Hour = data.Hour,
Date = data.Date,
ClientId = data.ClientId, // check uitvoeren van barber clients list
BarberId = barberId
};
BookAppointmentDataStore.Current.Appointments.Add(newBookAppointment);
return(Ok(newBookAppointment));
}
public void BookAsync(BookVisitViewModel viewModel)
{
AsyncManager.Parameters["viewModel"] = viewModel;
var calendarValidationMessages = _appointmentService.ValidateBook(new ValidateBookRequest
{
EmployeeId = viewModel.ConsultantId.Value,
DepartmentId =
Constants.SalesDepartmentId,
Start = viewModel.Start,
End = viewModel.End
}).ToList();
if (calendarValidationMessages.Any())
{
calendarValidationMessages.ForEach(message => ModelState.AddModelError("", message.Text));
return;
}
var bookVisitCommand = new BookVisit
{
Id = viewModel.Id,
AppointmentId = viewModel.AppointmentId,
LeadId = viewModel.LeadId,
Start = viewModel.Start,
End = viewModel.End,
ConsultantId = viewModel.ConsultantId
};
var bookAppointmentCommand = new BookAppointment
{
Id = viewModel.AppointmentId,
EmployeeId = viewModel.ConsultantId.Value,
DepartmentId = Constants.SalesDepartmentId,
Start = viewModel.Start,
End = viewModel.End,
};
_bus.Send(bookVisitCommand).Register <SalesReplies.ReturnCode>(returnCode => AsyncManager.Parameters["salesReturnCode"] = returnCode);
_bus.Send(bookAppointmentCommand).Register <CalendarReplies.ReturnCode>(returnCode => AsyncManager.Parameters["calendarReturnCode"] = returnCode);
}
public ActionResult Create(PatientViewModel model)
{
try
{
//model.Status = "Booked";
BookAppointment objAppoint = new BookAppointment();
//var claims1 = ClaimsPrincipal.Current.Identities.First();
objAppoint.PatientId = Int32.Parse(User.Claims.FirstOrDefault(x => x.Type == CLAIM_TYPE_NAME).Value);
//objAppoint.PatientId = Int32.Parse(User.Claims.);
objAppoint.DoctorId = model.SelectedDoctor;
objAppoint.AppointmentTime = model.AppointmentDate;
objAppoint.Status = "Booked";
_logger.LogInformation(objAppoint.PatientId.ToString());
_logger.LogInformation(objAppoint.DoctorId.ToString());
_logger.LogInformation(objAppoint.AppointmentTime.ToString());
_logger.LogInformation(objAppoint.Status);
apiProxy.PostAsync("patient/CreateAppointment", objAppoint);
//if (ModelState.IsValid)
//{
//var repo = new CustomersRepository();
//bool saved = repo.SaveCustomer(model);
//if (saved)
//{
// return RedirectToAction("Index");
//}
//}
return(RedirectToAction("Index", "Home"));
}
catch (ApplicationException ex)
{
throw ex;
}
}
public BookAppointment GetDoctorChamberForAppoint(int doctorId, int?doctorChmaberId)
{
Query = "SELECT * FROM ViewDoctorChamber WHERE DoctorId = @doctorId AND Id = @doctorChmaberId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("doctorId", doctorId);
Command.Parameters.AddWithValue("doctorChmaberId", doctorChmaberId);
Connection.Open();
Reader = Command.ExecuteReader();
BookAppointment bookAppointment = null;
while (Reader.Read())
{
bookAppointment = new BookAppointment();
bookAppointment.DoctorId = Convert.ToInt32(Reader["DoctorId"]);
bookAppointment.DoctorName = Reader["Name"].ToString();
bookAppointment.ChamberId = Convert.ToInt32(Reader["Id"]);
bookAppointment.ChamberName = Reader["ChamberName"].ToString();
}
Reader.Close();
Connection.Close();
return(bookAppointment);
}
public ActionResult BookAppointment(BookAppointment bookAppointment)
{
if (User.IsInRole("User"))
{
bookAppointment.SerialNo = GetUserData().UserId;
bookAppointment.UserId = GetUserData().UserId;
bookAppointment.UserName = GetUserData().Name;
bookAppointment.MobileNo = System.Web.HttpContext.Current.User.Identity.Name;
bookAppointment.Status = "Pending";
string message = aUserManager.ConfirmBookAppointment(bookAppointment);
if (message == "Success")
{
ViewBag.Message = "We have recieved your booking confirmation. If your payment process successful you will get confirmation message and Serial number.";
}
else
{
ViewBag.ErrorMessage = message;
}
}
ViewBag.GetName = GetUserData().Name;
ViewBag.GetDoctorDataForAppoint = Session["BookAppoint"] as BookAppointment;
return(View());
}
public ActionResult BookAppointment(BookAppointmentModel ba)
{
if (ModelState.IsValid)
{
DAL obj = new DAL();
BookAppointment b = new BookAppointment();
b.AccepterId = (int)Session["aid"];
b.CaseId = ba.CaseId;
b.Date = ba.Date;
b.Slot = ba.Slot;
b.Status = ba.Status;
bool res = obj.BookAppointment(b);
if (res == true)
{
ViewBag.msg = "Appointment Registered successfully";
}
else
{
ViewBag.msg = "errror";
}
}
return(View(ba));
}
public List <BookAppointment> GetUserAllAppointments(int userId)
{
Query = "SELECT * FROM BookAppointment WHERE UserId = @userId AND NOT Status = 'Pending' ORDER BY AppointDate DESC";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("userId", userId);
Connection.Open();
Reader = Command.ExecuteReader();
List <BookAppointment> bookAppointments = new List <BookAppointment>();
while (Reader.Read())
{
BookAppointment bookAppointment = new BookAppointment();
bookAppointment.DoctorName = Reader["DoctorName"].ToString();
bookAppointment.ChamberName = Reader["ChamberName"].ToString();
bookAppointment.Schedule = Reader["Schedule"].ToString();
bookAppointment.AppointDate = Reader["AppointDate"].ToString();
bookAppointment.SerialNo = Convert.ToInt32(Reader["SerialNo"]);
bookAppointments.Add(bookAppointment);
}
Reader.Close();
Connection.Close();
return(bookAppointments);
}
public BookAppointment GetBookAppointInfo(BookAppointment bookAppointment)
{
Query = "SELECT * FROM BookAppointment WHERE Id = @id AND DoctorId = @doctorId AND ChamberId = @chamberId AND UserId = @userId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("id", bookAppointment.BookAppointId);
Command.Parameters.AddWithValue("doctorId", bookAppointment.DoctorId);
Command.Parameters.AddWithValue("chamberId", bookAppointment.ChamberId);
Command.Parameters.AddWithValue("userId", bookAppointment.UserId);
Connection.Open();
Reader = Command.ExecuteReader();
BookAppointment bookAppointInfo = null;
if (Reader.Read())
{
bookAppointInfo = new BookAppointment();
bookAppointInfo.DoctorName = Reader["DoctorName"].ToString();
bookAppointInfo.AppointDate = Reader["AppointDate"].ToString();
bookAppointInfo.Schedule = Reader["Schedule"].ToString();
bookAppointInfo.SerialNo = Convert.ToInt32(Reader["SerialNo"]);
}
Reader.Close();
Connection.Close();
return(bookAppointInfo);
}
public int ConfirmAppointment(BookAppointment bookAppoint)
{
try
{
Query = "UPDATE BookAppointment SET Status = @status, SerialNo = @serialNo WHERE Id = @id AND UserId = @userdId AND DoctorId = @doctorId AND ChamberId = @chamberId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("status", bookAppoint.Status);
Command.Parameters.AddWithValue("serialNo", bookAppoint.SerialNo);
Command.Parameters.AddWithValue("id", bookAppoint.BookAppointId);
Command.Parameters.AddWithValue("userdId", bookAppoint.UserId);
Command.Parameters.AddWithValue("doctorId", bookAppoint.DoctorId);
Command.Parameters.AddWithValue("chamberId", bookAppoint.ChamberId);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
catch (Exception ex)
{
Connection.Close();
int rowAffected = 0;
return(rowAffected);
}
}
public IActionResult PatchWorkDay(int id, [FromBody] JsonPatchDocument <BookAppointmentForUpdateData> patchDoc)
{
BookAppointment bookAppointment = BookAppointmentDataStore.Current.Appointments.FirstOrDefault(ba => ba.Id == id);
if (bookAppointment == null)
{
return(NotFound());
}
BookAppointmentForUpdateData patchWorkDay = new BookAppointmentForUpdateData()
{
Hour = bookAppointment.Hour,
Cancel = bookAppointment.Cancel
};
patchDoc.ApplyTo(patchWorkDay);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
bookAppointment.Cancel = patchWorkDay.Cancel;
bookAppointment.Hour = patchWorkDay.Hour;
return(NoContent());
}
public BookAppointment GetBookAppointInfo(BookAppointment bookAppointment)
{
return(aMainAdminGateway.GetBookAppointInfo(bookAppointment));
}
public Profile GetClient(BookAppointment bookAppointment, IResolverContext ctx)
{
return(_profileService.GetAll().Where(p => p.Id == bookAppointment.ClientId).FirstOrDefault());
}
public void CreateAppointment()
{
try
{
DependencyService.Get <IProgressInterface>().Show();
//InitializeComponent();
BookAppointment objbookAppointment = new BookAppointment();
objbookAppointment.CompanyId = CompanyId;
objbookAppointment.ServiceId = ServiceID;
objbookAppointment.EmployeeId = EmpID;
objbookAppointment.CustomerIdsCommaSeperated = CustID.ToString();
var sH = TimePeriods;
var tf = sH.Split(' ', '-');
var jj = tf[0] + ' ' + tf[1];
DateTime timejone = Convert.ToDateTime(jj);
var StartHour = timejone.ToString("HH");
var StartMinutes = timejone.ToString("mm");
objbookAppointment.StartHour = StartHour;
objbookAppointment.StartMinute = StartMinutes;
objbookAppointment.EndHour = EndHour;
objbookAppointment.EndMinute = EndMinute;
objbookAppointment.IsAdded = true;
objbookAppointment.Message = "";
var GetAllCustomerData = GetAllCustomer();
List <int> custIDs = GetAllCustomerData.Select(x => x.Id).ToList();
custIDs = custIDs.Where(x => x == CustID).ToList();
objbookAppointment.CustomerIds = custIDs;
var sDate = dateOfBooking.ToString("yyyy-MM-dd T HH:mm:ss");
objbookAppointment.Start = sDate;
var eeDate = dateOfBooking.ToString("yyyy-MM-dd T HH:mm:ss");
objbookAppointment.End = eeDate;
if (newAppointmentsPicker.SelectedItem != null)
{
string selectedValue = (newAppointmentsPicker.SelectedItem).ToString();
Data.TryGetValue(selectedValue, out StatusId);
}
objbookAppointment.Status = StatusId;
objbookAppointment.Notes = "";
var Url = Application.Current.Properties["DomainUrl"] + "/api/booking/BookAppointment";
var SerializedData = JsonConvert.SerializeObject(objbookAppointment);
var result = PostData("POST", SerializedData, Url);
dynamic data = JObject.Parse(result);
var msg = Convert.ToString(data.Message);
DisplayAlert("Success", msg, "ok");
var date = book.Split(',');
DateTime d = Convert.ToDateTime(date[1]);
System.DateTime today = d;
int currentDayOfWeek = (int)today.DayOfWeek;
System.DateTime sunday = today.AddDays(-currentDayOfWeek);
System.DateTime monday = sunday.AddDays(1);
if (currentDayOfWeek == 0)
{
monday = monday.AddDays(-7);
}
var dates = Enumerable.Range(0, 7).Select(days => monday.AddDays(days)).ToList();
var eee = dates[0];
var fullDate = eee.ToString("ddd dd-MMM-yyyy");
Navigation.PushAsync(new SetAppointmentPage("", "", fullDate));
}
catch (Exception ex)
{
var msgs = ex.Message;
DisplayAlert("success", msgs, "ok");
ex.ToString();
}
}
public void UpdateAppointments()
{
try
{
//string[] AppointmentDate = { };
//string[] TimeAppointment = { };
//string[] hours = { };
//string[] Endmins = { };
//string[] Endmin = { };
//string Time = UpdateAppointmentTime.Text;
//if (Time != null)
//{
// TimeAppointment = Time.Split('-');
// hours = TimeAppointment[0].Split(':');
// Endmins = TimeAppointment[1].Split(':');
// Endmin = Endmins[1].Split(' ');
//}
//if (AppointmentsPicker.SelectedItem != null)
//{
// string selectedValue = (AppointmentsPicker.SelectedItem).ToString();
// Data.TryGetValue(selectedValue, out StatusId);
//}
//var GetAllCustomerData = GetAllCustomer();
//List<int> custIDs = GetAllCustomerData.Select(z => z.Id).ToList();
//UpdatebookAppointment = new UpdateBookAppointment();
//UpdatebookAppointment.Id = Application.Current.Properties["BookingID"].ToString();
//UpdatebookAppointment.CompanyId = Convert.ToInt32(Application.Current.Properties["CompanyId"]);
//UpdatebookAppointment.EmployeeId = EmpID;
//UpdatebookAppointment.ServiceId = ServiceID;
//UpdatebookAppointment.CustomerIdsCommaSeperated = CustID.ToString();
//UpdatebookAppointment.StartHour = Convert.ToInt32(hours[0]);
//UpdatebookAppointment.StartMinute = 0;
//UpdatebookAppointment.EndHour = 0;
//UpdatebookAppointment.EndMinute = Convert.ToInt32(Endmin[0]);
//UpdatebookAppointment.IsAdded = true;
//UpdatebookAppointment.Message = UpdateComment.Text;
//UpdatebookAppointment.Notes = UpdateComment.Text;
//UpdatebookAppointment.CustomerIds = custIDs;
//UpdatebookAppointment.Start = dateOfBooking;
//UpdatebookAppointment.End = dateOfBooking;
//UpdatebookAppointment.Status = StatusId;
UpdatebookAppointment = new UpdateBookAppointment();
UpdatebookAppointment.Id = BookingID;
UpdatebookAppointment.CompanyId = CompanyId;
UpdatebookAppointment.ServiceId = ServiceID;
UpdatebookAppointment.EmployeeId = EmpID;
UpdatebookAppointment.CustomerIdsCommaSeperated = CustID.ToString();
UpdatebookAppointment.StartHour = StartHour;
UpdatebookAppointment.StartMinute = StartMinutes;
UpdatebookAppointment.EndHour = EndHour;
UpdatebookAppointment.EndMinute = EndMinute;
UpdatebookAppointment.IsAdded = true;
UpdatebookAppointment.Message = "";
var GetAllCustomerData = GetAllCustomer();
List <int> custIDs = GetAllCustomerData.Select(x => x.Id).ToList();
custIDs = custIDs.Where(x => x == CustID).ToList();
UpdatebookAppointment.CustomerIds = custIDs;
var sDate = dateOfBooking.ToString("yyyy-MM-dd T HH:mm:ss");
UpdatebookAppointment.Start = sDate;
var eeDate = dateOfBooking.ToString("yyyy-MM-dd T HH:mm:ss");
UpdatebookAppointment.End = eeDate;
if (AppointmentsPicker.SelectedItem != null)
{
string selectedValue = (AppointmentsPicker.SelectedItem).ToString();
Data.TryGetValue(selectedValue, out StatusId);
}
UpdatebookAppointment.Status = StatusId;
UpdatebookAppointment.Notes = "";
var SerializedData = JsonConvert.SerializeObject(UpdatebookAppointment);
var apiUrl = Application.Current.Properties["DomainUrl"] + "api/booking/UpdateBooking";
var result = PostData("POST", SerializedData, apiUrl);
BookAppointment objBookappointments = new BookAppointment();
objBookappointments.CompanyId = UpdatebookAppointment.CompanyId;
objBookappointments.CustomerIdsCommaSeperated = UpdatebookAppointment.CustomerIdsCommaSeperated;
objBookappointments.EmployeeId = UpdatebookAppointment.EmployeeId;
objBookappointments.ServiceId = UpdatebookAppointment.ServiceId;
objBookappointments.StartHour = UpdatebookAppointment.StartHour;
objBookappointments.StartMinute = UpdatebookAppointment.StartMinute;
objBookappointments.EndHour = UpdatebookAppointment.EndHour;
objBookappointments.EndMinute = UpdatebookAppointment.EndMinute;
objBookappointments.IsAdded = UpdatebookAppointment.IsAdded;
objBookappointments.Message = UpdatebookAppointment.Message;
objBookappointments.Notes = UpdatebookAppointment.Notes;
objBookappointments.CustomerIds = UpdatebookAppointment.CustomerIds;
objBookappointments.Start = UpdatebookAppointment.Start.ToString();
objBookappointments.End = UpdatebookAppointment.End.ToString();
objBookappointments.Status = UpdatebookAppointment.Status;
dynamic data = JObject.Parse(result);
var msg = Convert.ToString(data.Message);
DisplayAlert("Success", msg, "ok");
for (int PageIndex = Navigation.NavigationStack.Count - 1; PageIndex >= 4; PageIndex--)
{
Navigation.RemovePage(Navigation.NavigationStack[PageIndex]);
}
// Navigation.PopAsync(true);
Navigation.PushAsync(new AddAppointmentsPage(objBookappointments));
}
catch (Exception e)
{
e.ToString();
}
}
public ManageAppointment GetDoctorAppointInfo(BookAppointment bookAppoint)
{
Query = "SELECT * FROM ManageAppointVM WHERE DoctorId = @doctorId AND MedicalId = @chamberId AND Expired = 'False'";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("doctorId", bookAppoint.DoctorId);
Command.Parameters.AddWithValue("chamberId", bookAppoint.ChamberId);
Connection.Open();
Reader = Command.ExecuteReader();
ManageAppointment manageAppointment = null;
while (Reader.Read())
{
manageAppointment = new ManageAppointment();
manageAppointment.Id = Convert.ToInt32(Reader["Id"]);
manageAppointment.SatAvailableAppoint = Convert.ToInt32(Reader["SatAvailableAppoint"]);
manageAppointment.SunAvailableAppoint = Convert.ToInt32(Reader["SunAvailableAppoint"]);
manageAppointment.MonAvailableAppoint = Convert.ToInt32(Reader["MonAvailableAppoint"]);
manageAppointment.TueAvailableAppoint = Convert.ToInt32(Reader["TueAvailableAppoint"]);
manageAppointment.WedAvailableAppoint = Convert.ToInt32(Reader["WedAvailableAppoint"]);
manageAppointment.ThuAvailableAppoint = Convert.ToInt32(Reader["ThuAvailableAppoint"]);
manageAppointment.FriAvailableAppoint = Convert.ToInt32(Reader["FriAvailableAppoint"]);
manageAppointment.TotalAvailableAppoint = Convert.ToInt32(Reader["TotalAvailableAppoint"]);
manageAppointment.RemainingAppoint = Convert.ToInt32(Reader["RemainingAppoint"]);
manageAppointment.TotalAppoint = Convert.ToInt32(Reader["TotalAppoint"]);
manageAppointment.OrderedAppoint = Convert.ToInt32(Reader["AppointAmount"]);
manageAppointment.DoctorId = Convert.ToInt32(Reader["DoctorId"]);
manageAppointment.MedicalId = Convert.ToInt32(Reader["MedicalId"]);
}
Reader.Close();
Connection.Close();
if (manageAppointment == null)
{
Query = "SELECT * FROM ManageAppointVM WHERE DoctorId = @doctorId AND DoctorChamberId = @chamberId AND Expired = 'False'";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("doctorId", bookAppoint.DoctorId);
Command.Parameters.AddWithValue("chamberId", bookAppoint.ChamberId);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
manageAppointment = new ManageAppointment();
manageAppointment.Id = Convert.ToInt32(Reader["Id"]);
manageAppointment.SatAvailableAppoint = Convert.ToInt32(Reader["SatAvailableAppoint"]);
manageAppointment.SunAvailableAppoint = Convert.ToInt32(Reader["SunAvailableAppoint"]);
manageAppointment.MonAvailableAppoint = Convert.ToInt32(Reader["MonAvailableAppoint"]);
manageAppointment.TueAvailableAppoint = Convert.ToInt32(Reader["TueAvailableAppoint"]);
manageAppointment.WedAvailableAppoint = Convert.ToInt32(Reader["WedAvailableAppoint"]);
manageAppointment.ThuAvailableAppoint = Convert.ToInt32(Reader["ThuAvailableAppoint"]);
manageAppointment.FriAvailableAppoint = Convert.ToInt32(Reader["FriAvailableAppoint"]);
manageAppointment.TotalAvailableAppoint = Convert.ToInt32(Reader["TotalAvailableAppoint"]);
manageAppointment.RemainingAppoint = Convert.ToInt32(Reader["RemainingAppoint"]);
manageAppointment.TotalAppoint = Convert.ToInt32(Reader["TotalAppoint"]);
manageAppointment.OrderedAppoint = Convert.ToInt32(Reader["AppointAmount"]);
manageAppointment.DoctorId = Convert.ToInt32(Reader["DoctorId"]);
manageAppointment.DoctorChamberId = Convert.ToInt32(Reader["DoctorChamberId"]);
}
Reader.Close();
Connection.Close();
}
return(manageAppointment);
}
public void BookAsync(BookVisitViewModel viewModel)
{
AsyncManager.Parameters["viewModel"] = viewModel;
var calendarValidationMessages = _appointmentService.ValidateBook(new ValidateBookRequest
{
EmployeeId = viewModel.ConsultantId.Value,
DepartmentId =
Constants.SalesDepartmentId,
Start = viewModel.Start,
End = viewModel.End
}).ToList();
if (calendarValidationMessages.Any())
{
calendarValidationMessages.ForEach(message => ModelState.AddModelError("", message.Text));
return;
}
var bookVisitCommand = new BookVisit
{
Id = viewModel.Id,
AppointmentId = viewModel.AppointmentId,
LeadId = viewModel.LeadId,
Start = viewModel.Start,
End = viewModel.End,
ConsultantId = viewModel.ConsultantId
};
var bookAppointmentCommand = new BookAppointment
{
Id = viewModel.AppointmentId,
EmployeeId = viewModel.ConsultantId.Value,
DepartmentId = Constants.SalesDepartmentId,
Start = viewModel.Start,
End = viewModel.End,
};
_bus.Send(bookVisitCommand).Register<SalesReplies.ReturnCode>(returnCode => AsyncManager.Parameters["salesReturnCode"] = returnCode);
_bus.Send(bookAppointmentCommand).Register<CalendarReplies.ReturnCode>(returnCode => AsyncManager.Parameters["calendarReturnCode"] = returnCode);
}
public void CreateAppointment()
{
try
{
BookAppointment objbookAppointment = new BookAppointment();
objbookAppointment.CompanyId = CompanyId;
objbookAppointment.ServiceId = ServiceID;
objbookAppointment.EmployeeId = EmpID;
objbookAppointment.CustomerIdsCommaSeperated = CustID.ToString();
var sH = TimePeriods;
var tf = sH.Split(' ', '-');
var jj = tf[0] + ' ' + tf[1];
DateTime timejone = Convert.ToDateTime(jj);
var StartHour = timejone.ToString("HH");
var StartMinutes = timejone.ToString("mm");
objbookAppointment.StartHour = StartHour;
objbookAppointment.StartMinute = StartMinutes;
objbookAppointment.EndHour = EndHour;
objbookAppointment.EndMinute = EndMinute;
objbookAppointment.IsAdded = true;
objbookAppointment.Message = "";
var GetAllCustomerData = GetAllCustomer();
List <int> custIDs = GetAllCustomerData.Select(x => x.Id).ToList();
custIDs = custIDs.Where(x => x == CustID).ToList();
objbookAppointment.CustomerIds = custIDs;
var sDate = dateOfBooking.ToString("yyyy-MM-dd T HH:mm:ss");
objbookAppointment.Start = sDate;
var eeDate = dateOfBooking.ToString("yyyy-MM-dd T HH:mm:ss");
objbookAppointment.End = eeDate;
if (newAppointmentsPicker.SelectedItem != null)
{
string selectedValue = (newAppointmentsPicker.SelectedItem).ToString();
Data.TryGetValue(selectedValue, out StatusId);
}
objbookAppointment.Status = StatusId;
objbookAppointment.Notes = "";
var Url = Application.Current.Properties["DomainUrl"] + "/api/booking/BookAppointment";
var SerializedData = JsonConvert.SerializeObject(objbookAppointment);
var result = PostData("POST", SerializedData, Url);
dynamic data = JObject.Parse(result);
var msg = Convert.ToString(data.Message);
DisplayAlert("Success", msg, "ok");
for (int PageIndex = Navigation.NavigationStack.Count - 1; PageIndex >= 5; PageIndex--)
{
Navigation.RemovePage(Navigation.NavigationStack[PageIndex]);
}
// Navigation.PopAsync(true);
Navigation.PushAsync(new AddAppointmentsPage(objbookAppointment));
}
catch (Exception e)
{
e.ToString();
}
}
public ManageAppointment GetDoctorAppointInfo(BookAppointment bookAppoint)
{
return(aMainAdminGateway.GetDoctorAppointInfo(bookAppoint));
}
public BookAppointment SaveAppointment(BookAppointment bApp)
{
return(_bookAppService.SaveAppointment(bApp));
}