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"));
}
