public int UpdateDoctorAppointInfo(ManageAppointment manageAppointment) { int rowAffected = 0; try { if (manageAppointment.MedicalId > 0) { Query = "UPDATE ManageAppointment SET SatAvailableAppoint = @satAppoint, SunAvailableAppoint = @sunAppoint, MonAvailableAppoint = @monAppoint, TueAvailableAppoint = @tueAppoint, WedAvailableAppoint = @wedAppoint, ThuAvailableAppoint = @ThuAppoint, FriAvailableAppoint = @friAppoint, TotalAvailableAppoint = @totalAppoint WHERE Id = @id AND DoctorId = @doctorId AND MedicalId = @medicalId"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("satAppoint", manageAppointment.SatAvailableAppoint); Command.Parameters.AddWithValue("sunAppoint", manageAppointment.SunAvailableAppoint); Command.Parameters.AddWithValue("monAppoint", manageAppointment.MonAvailableAppoint); Command.Parameters.AddWithValue("tueAppoint", manageAppointment.TueAvailableAppoint); Command.Parameters.AddWithValue("wedAppoint", manageAppointment.WedAvailableAppoint); Command.Parameters.AddWithValue("thuAppoint", manageAppointment.ThuAvailableAppoint); Command.Parameters.AddWithValue("friAppoint", manageAppointment.FriAvailableAppoint); Command.Parameters.AddWithValue("totalAppoint", manageAppointment.TotalAvailableAppoint); Command.Parameters.AddWithValue("id", manageAppointment.Id); Command.Parameters.AddWithValue("doctorId", manageAppointment.DoctorId); Command.Parameters.AddWithValue("medicalId", manageAppointment.MedicalId); Connection.Open(); rowAffected = Command.ExecuteNonQuery(); Connection.Close(); } if (manageAppointment.DoctorChamberId > 0) { Query = "UPDATE ManageAppointment SET SatAvailableAppoint = @satAppoint, SunAvailableAppoint = @sunAppoint, MonAvailableAppoint = @monAppoint, TueAvailableAppoint = @tueAppoint, WedAvailableAppoint = @wedAppoint, ThuAvailableAppoint = @ThuAppoint, FriAvailableAppoint = @friAppoint, TotalAvailableAppoint = @totalAppoint WHERE Id = @id AND DoctorId = @doctorId AND DoctorChamberId = @doctorChamberId"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("satAppoint", manageAppointment.SatAvailableAppoint); Command.Parameters.AddWithValue("sunAppoint", manageAppointment.SunAvailableAppoint); Command.Parameters.AddWithValue("monAppoint", manageAppointment.MonAvailableAppoint); Command.Parameters.AddWithValue("tueAppoint", manageAppointment.TueAvailableAppoint); Command.Parameters.AddWithValue("wedAppoint", manageAppointment.WedAvailableAppoint); Command.Parameters.AddWithValue("thuAppoint", manageAppointment.ThuAvailableAppoint); Command.Parameters.AddWithValue("friAppoint", manageAppointment.FriAvailableAppoint); Command.Parameters.AddWithValue("totalAppoint", manageAppointment.TotalAvailableAppoint); Command.Parameters.AddWithValue("id", manageAppointment.Id); Command.Parameters.AddWithValue("doctorId", manageAppointment.DoctorId); Command.Parameters.AddWithValue("doctorChamberId", manageAppointment.DoctorChamberId); Connection.Open(); rowAffected = Command.ExecuteNonQuery(); Connection.Close(); } UpdateDoctorAppointOrder(manageAppointment.Id, manageAppointment.RemainingAppoint); return(rowAffected); } catch (Exception ex) { Connection.Close(); return(rowAffected); } }
public string ChamberAppointmentAvailability(ManageAppointment manageAppointment) { int rowAffected = aDoctorGateway.ChamberAppointmentAvailability(manageAppointment); if (rowAffected > 0) { return("Success"); } else { return("Manage Appointment availability changing failed."); } }
public string UpdateDoctorAppointInfo(ManageAppointment manageAppointment) { int rowAffected = aMainAdminGateway.UpdateDoctorAppointInfo(manageAppointment); if (rowAffected > 0) { return("Success"); } else { return("Appoint confirmation processing failed"); } }
private void CreateOrderForChamber(ManageAppointment manageAppointment) { int manageId = aDoctorManager.GetManageId(manageAppointment.DoctorId, manageAppointment.MedicalId, manageAppointment.DoctorChamberId); DoctorAppointOrder doctorAppointOrder = new DoctorAppointOrder(); doctorAppointOrder.ManageAppointId = manageId; doctorAppointOrder.AppointAmount = 0; doctorAppointOrder.TotalPrice = 0; DateTime orderDate = new DateTime(1971, 2, 1); doctorAppointOrder.OrderDate = orderDate; doctorAppointOrder.ExpireDate = orderDate; doctorAppointOrder.RemainingAppoint = 0; doctorAppointOrder.PaymentMethod = ""; doctorAppointOrder.TrnxId = ""; doctorAppointOrder.Expired = false; doctorAppointOrder.Status = "Active"; int rowAffected = aDoctorManager.CreateOrderForChamber(doctorAppointOrder); }
public string UpdateManageAppointment(ManageAppointment manageAppointment) { if (manageAppointment.MedicalId == null) { manageAppointment.MedicalId = 0; } if (manageAppointment.DoctorChamberId == null) { manageAppointment.DoctorChamberId = 0; } int rowAffected = aDoctorGateway.UpdateManageAppointment(manageAppointment); if (rowAffected > 0) { return("Success"); } else { return("Manage Appointment updating failed."); } }
private ManageAppointment GetManageAppointmentInfo(int doctorId, int medicalId) { Connection.Close(); Query = "SELECT * FROM ManageAppointVM WHERE DoctorId = @doctorId AND MedicalId = @medicalId AND Expired = 'False'"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("doctorId", doctorId); Command.Parameters.AddWithValue("medicalId", medicalId); Connection.Open(); Reader = Command.ExecuteReader(); ManageAppointment manageAppointment = new ManageAppointment(); while (Reader.Read()) { manageAppointment.Id = Convert.ToInt32(Reader["Id"]); manageAppointment.SatCapacity = Convert.ToInt32(Reader["SatCapacity"]); manageAppointment.SunCapacity = Convert.ToInt32(Reader["SunCapacity"]); manageAppointment.MonCapacity = Convert.ToInt32(Reader["MonCapacity"]); manageAppointment.TueCapacity = Convert.ToInt32(Reader["TueCapacity"]); manageAppointment.WedCapacity = Convert.ToInt32(Reader["WedCapacity"]); manageAppointment.ThuCapacity = Convert.ToInt32(Reader["ThuCapacity"]); manageAppointment.FriCapacity = Convert.ToInt32(Reader["FriCapacity"]); 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.OnlineAppointment = Convert.ToBoolean(Reader["OnlineAppoint"]); manageAppointment.UsedAppoint = Convert.ToInt32(Reader["UsedAppoint"]); manageAppointment.TotalAvailableAppoint = Convert.ToInt32(Reader["TotalAvailableAppoint"]); manageAppointment.DoctorId = Convert.ToInt32(Reader["DoctorId"]); manageAppointment.MedicalId = Convert.ToInt32(Reader["MedicalId"]); manageAppointment.OrderedAppoint = Convert.ToInt32(Reader["AppointAmount"]); manageAppointment.RemainingAppoint = Convert.ToInt32(Reader["RemainingAppoint"]); manageAppointment.OrderExpireDate = Convert.ToDateTime(Reader["ExpireDate"]); } return(manageAppointment); }
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 ActionResult ManageAppointment(bool onlineAvailability, int?medicalId, int?doctorChamberId) { int doctorId = GetDoctorData().Id; if (User.IsInRole("Doctor")) { if (medicalId != null) { if (aDoctorManager.CheckManageAppointment(doctorId, medicalId)) { string message = aDoctorManager.ExistAppointmentAvailability(onlineAvailability, doctorId, medicalId); if (message == "Success") { ViewBag.Message = "Manage Appointment availability changed successfully"; } else { ViewBag.ErrorMessage = message; } } else { ManageAppointment manageAppointment = new ManageAppointment(); manageAppointment.UsedAppoint = 0; manageAppointment.TotalAvailableAppoint = 0; manageAppointment.DoctorId = doctorId; manageAppointment.MedicalId = Convert.ToInt32(medicalId); manageAppointment.DoctorChamberId = 0; manageAppointment.OnlineAppointment = onlineAvailability; string message = aDoctorManager.AppointmentAvailability(manageAppointment); if (message == "Success") { CreateOrderForChamber(manageAppointment); ViewBag.Message = "Manage Appointment availability changed successfully"; } else { ViewBag.ErrorMessage = message; } } } if (doctorChamberId != null) { if (aDoctorManager.CheckChamberManageAppointment(doctorId, doctorChamberId)) { string message = aDoctorManager.ExistChamberAppointmentAvailability(onlineAvailability, doctorId, doctorChamberId); if (message == "Success") { ViewBag.Message = "Manage Appointment availability changed successfully"; } else { ViewBag.ErrorMessage = message; } } else { ManageAppointment manageAppointment = new ManageAppointment(); manageAppointment.UsedAppoint = 0; manageAppointment.TotalAvailableAppoint = 0; manageAppointment.DoctorId = doctorId; manageAppointment.MedicalId = 0; manageAppointment.DoctorChamberId = (int)doctorChamberId; manageAppointment.OnlineAppointment = onlineAvailability; string message = aDoctorManager.ChamberAppointmentAvailability(manageAppointment); if (message == "Success") { CreateOrderForChamber(manageAppointment); ViewBag.Message = "Manage Appointment availability changed successfully"; } else { ViewBag.ErrorMessage = message; } } } } List <ViewDoctors> doctorsChambers = aDoctorManager.GetDoctorChambers(doctorId); List <DoctorChamber> doctorOwnChamber = aDoctorManager.GetDoctorOwnChamber(doctorId); List <OrderStatus> orderDetails = aDoctorManager.GetOrderStatus(doctorId); ViewBag.DoctorChambers = doctorsChambers; ViewBag.DoctorOwnChambers = doctorOwnChamber; ViewBag.OrderStatus = orderDetails; ViewBag.GetName = GetDoctorData().Name; return(View()); }
public ActionResult UpdateManageAppointment(ManageAppointment manageAppointment) { if (User.IsInRole("Doctor")) { ManageAppointment previousManageInfo = aDoctorManager.GetDoctorChamberManageInfo(GetDoctorData().Id, manageAppointment.MedicalId, manageAppointment.DoctorChamberId); manageAppointment.DoctorId = GetDoctorData().Id; manageAppointment.UsedAppoint = manageAppointment.SatCapacity + manageAppointment.SunCapacity + manageAppointment.MonCapacity + manageAppointment.TueCapacity + manageAppointment.WedCapacity + manageAppointment.ThuCapacity + manageAppointment.FriCapacity; if (manageAppointment.TotalAvailableAppoint == 0) { manageAppointment.SatAvailableAppoint = manageAppointment.SatCapacity; manageAppointment.SunAvailableAppoint = manageAppointment.SunCapacity; manageAppointment.MonAvailableAppoint = manageAppointment.MonCapacity; manageAppointment.TueAvailableAppoint = manageAppointment.TueCapacity; manageAppointment.WedAvailableAppoint = manageAppointment.WedCapacity; manageAppointment.ThuAvailableAppoint = manageAppointment.ThuCapacity; manageAppointment.FriAvailableAppoint = manageAppointment.FriCapacity; manageAppointment.TotalAvailableAppoint = manageAppointment.UsedAppoint; } else { if (manageAppointment.SatCapacity > previousManageInfo.SatCapacity) { manageAppointment.SatAvailableAppoint = (manageAppointment.SatCapacity - previousManageInfo.SatAvailableAppoint) + previousManageInfo.SatAvailableAppoint; } if (manageAppointment.SunCapacity > previousManageInfo.SunCapacity) { manageAppointment.SunAvailableAppoint = (manageAppointment.SunCapacity - previousManageInfo.SunAvailableAppoint) + previousManageInfo.SunAvailableAppoint; } if (manageAppointment.MonCapacity > previousManageInfo.MonCapacity) { manageAppointment.MonAvailableAppoint = (manageAppointment.MonCapacity - previousManageInfo.MonAvailableAppoint) + previousManageInfo.MonAvailableAppoint; } if (manageAppointment.TueCapacity > previousManageInfo.TueCapacity) { manageAppointment.TueAvailableAppoint = (manageAppointment.TueCapacity - previousManageInfo.TueAvailableAppoint) + previousManageInfo.TueAvailableAppoint; } if (manageAppointment.WedCapacity > previousManageInfo.WedCapacity) { manageAppointment.WedAvailableAppoint = (manageAppointment.WedCapacity - previousManageInfo.WedAvailableAppoint) + previousManageInfo.WedAvailableAppoint; } if (manageAppointment.ThuCapacity > previousManageInfo.ThuCapacity) { manageAppointment.ThuAvailableAppoint = (manageAppointment.ThuCapacity - previousManageInfo.ThuAvailableAppoint) + previousManageInfo.ThuAvailableAppoint; } if (manageAppointment.FriCapacity > previousManageInfo.FriCapacity) { manageAppointment.FriAvailableAppoint = (manageAppointment.FriCapacity - previousManageInfo.FriAvailableAppoint) + previousManageInfo.FriAvailableAppoint; } if (manageAppointment.SatCapacity < previousManageInfo.SatCapacity) { manageAppointment.SatAvailableAppoint = previousManageInfo.SatAvailableAppoint - (previousManageInfo.SatAvailableAppoint - manageAppointment.SatCapacity); } if (manageAppointment.SunCapacity < previousManageInfo.SunCapacity) { manageAppointment.SunAvailableAppoint = previousManageInfo.SunAvailableAppoint - (previousManageInfo.SunAvailableAppoint - manageAppointment.SunCapacity); } if (manageAppointment.MonCapacity < previousManageInfo.MonCapacity) { manageAppointment.MonAvailableAppoint = previousManageInfo.MonAvailableAppoint - (previousManageInfo.MonAvailableAppoint - manageAppointment.MonCapacity); } if (manageAppointment.TueCapacity < previousManageInfo.TueCapacity) { manageAppointment.TueAvailableAppoint = previousManageInfo.TueAvailableAppoint - (previousManageInfo.TueAvailableAppoint - manageAppointment.TueCapacity); } if (manageAppointment.WedCapacity < previousManageInfo.WedCapacity) { manageAppointment.WedAvailableAppoint = previousManageInfo.WedAvailableAppoint - (previousManageInfo.WedAvailableAppoint - manageAppointment.WedCapacity); } if (manageAppointment.ThuCapacity < previousManageInfo.ThuCapacity) { manageAppointment.ThuAvailableAppoint = previousManageInfo.ThuAvailableAppoint - (previousManageInfo.ThuAvailableAppoint - manageAppointment.ThuCapacity); } if (manageAppointment.FriCapacity < previousManageInfo.FriCapacity) { manageAppointment.FriAvailableAppoint = previousManageInfo.FriAvailableAppoint - (previousManageInfo.FriAvailableAppoint - manageAppointment.FriCapacity); } if (manageAppointment.SatCapacity == previousManageInfo.SatCapacity) { manageAppointment.SatAvailableAppoint = previousManageInfo.SatCapacity; } if (manageAppointment.SunCapacity == previousManageInfo.SunCapacity) { manageAppointment.SunAvailableAppoint = previousManageInfo.SunCapacity; } if (manageAppointment.MonCapacity == previousManageInfo.MonCapacity) { manageAppointment.MonAvailableAppoint = previousManageInfo.MonCapacity; } if (manageAppointment.TueCapacity == previousManageInfo.TueCapacity) { manageAppointment.TueAvailableAppoint = previousManageInfo.TueCapacity; } if (manageAppointment.WedCapacity == previousManageInfo.WedCapacity) { manageAppointment.WedAvailableAppoint = previousManageInfo.WedCapacity; } if (manageAppointment.ThuCapacity == previousManageInfo.ThuCapacity) { manageAppointment.ThuAvailableAppoint = previousManageInfo.ThuCapacity; } if (manageAppointment.FriCapacity == previousManageInfo.FriCapacity) { manageAppointment.FriAvailableAppoint = previousManageInfo.FriCapacity; } manageAppointment.TotalAvailableAppoint = manageAppointment.SatAvailableAppoint + manageAppointment.SunAvailableAppoint + manageAppointment.MonAvailableAppoint + manageAppointment.TueAvailableAppoint + manageAppointment.WedAvailableAppoint + manageAppointment.ThuAvailableAppoint + manageAppointment.FriAvailableAppoint; } if (DateTime.Now.Date > manageAppointment.OrderExpireDate) { TempData["ErrorMessage"] = "Your ordered appointments are expired. Please Buy Appointment and your remaining appointments will be added."; } else { if (manageAppointment.TotalAvailableAppoint > manageAppointment.RemainingAppoint) { TempData["ErrorMessage"] = "Your appointment capacity limit exceeded! Please buy more appointment."; } else { string message = aDoctorManager.UpdateManageAppointment(manageAppointment); if (message == "Success") { TempData["Message"] = "Manage Appointment updated successfully."; } else { TempData["ErrorMessage"] = message; } } } } return(RedirectToAction("ManageAppointment", "Doctor")); }