public string EditDoctorChamberSchedule(DoctorChamber doctorChamber)
{
int rowAffected = aDoctorGateway.EditDoctorChamberSchedule(doctorChamber);
if (rowAffected > 0)
{
return("Success");
}
else
{
return("Doctor fees editing failed.");
}
}
public string AddNewChamber(DoctorChamber aDoctorChamber)
{
int rowAffected = aDoctorGateway.AddNewChamber(aDoctorChamber);
if (rowAffected > 0)
{
return("Success");
}
else
{
return("Doctor's new chamber adding failed.");
}
}
private List <DoctorChamber> GetDoctorChamberSearchDetails(int doctorId)
{
Connection.Close();
Query = "SELECT * FROM ViewDoctorChamber WHERE DoctorId = @id";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("id", doctorId);
Connection.Open();
Reader = Command.ExecuteReader();
List <DoctorChamber> viewDoctorChambers = new List <DoctorChamber>();
while (Reader.Read())
{
DoctorChamber viewChamber = new DoctorChamber();
viewChamber.Id = Convert.ToInt32(Reader["Id"]);
viewChamber.ChamberName = Reader["ChamberName"].ToString();
viewChamber.Address = Reader["Address"].ToString();
viewChamber.Area = Reader["Area"].ToString();
viewChamber.City = Reader["City"].ToString();
viewChamber.ContactNo = Reader["ContactNo"].ToString();
viewChamber.PhoneNo = Reader["PhoneNo"].ToString();
viewChamber.Fee = Convert.ToInt32(Reader["Fee"]);
viewChamber.ReturningFee = Convert.ToInt32(Reader["ReturningFee"]);
viewChamber.Sat = Convert.ToBoolean(Reader["Sat"]);
viewChamber.Sun = Convert.ToBoolean(Reader["Sun"]);
viewChamber.Mon = Convert.ToBoolean(Reader["Mon"]);
viewChamber.Tue = Convert.ToBoolean(Reader["Tue"]);
viewChamber.Wed = Convert.ToBoolean(Reader["Wed"]);
viewChamber.Thu = Convert.ToBoolean(Reader["Thu"]);
viewChamber.Fri = Convert.ToBoolean(Reader["Fri"]);
viewChamber.SatFromTime = Reader["SatTime"].ToString();
viewChamber.SunFromTime = Reader["SunTime"].ToString();
viewChamber.MonFromTime = Reader["MonTime"].ToString();
viewChamber.TueFromTime = Reader["TueTime"].ToString();
viewChamber.WedFromTime = Reader["WedTime"].ToString();
viewChamber.ThuFromTime = Reader["ThuTime"].ToString();
viewChamber.FriFromTime = Reader["FriTime"].ToString();
viewChamber.ManageAppointment = GetChamberManageAppointmentInfo(doctorId, viewChamber.Id);
viewDoctorChambers.Add(viewChamber);
}
return(viewDoctorChambers);
}
private void GenerateDoctorChamberSchedule(DoctorChamber aDoctorChamber)
{
if (aDoctorChamber.SatFromTime != null && aDoctorChamber.SatToTime != null)
{
aDoctorChamber.SatFromTime = aDoctorChamber.SatFromTime + " - " + aDoctorChamber.SatToTime;
}
if (aDoctorChamber.SunFromTime != null && aDoctorChamber.SunToTime != null)
{
aDoctorChamber.SunFromTime = aDoctorChamber.SunFromTime + " - " + aDoctorChamber.SunToTime;
}
if (aDoctorChamber.MonFromTime != null && aDoctorChamber.MonToTime != null)
{
aDoctorChamber.MonFromTime = aDoctorChamber.MonFromTime + " - " + aDoctorChamber.MonToTime;
}
if (aDoctorChamber.TueFromTime != null && aDoctorChamber.TueToTime != null)
{
aDoctorChamber.TueFromTime = aDoctorChamber.TueFromTime + " - " + aDoctorChamber.TueToTime;
}
if (aDoctorChamber.WedFromTime != null && aDoctorChamber.WedToTime != null)
{
aDoctorChamber.WedFromTime = aDoctorChamber.WedFromTime + " - " + aDoctorChamber.WedToTime;
}
if (aDoctorChamber.ThuFromTime != null && aDoctorChamber.ThuToTime != null)
{
aDoctorChamber.ThuFromTime = aDoctorChamber.ThuFromTime + " - " + aDoctorChamber.ThuToTime;
}
if (aDoctorChamber.FriFromTime != null && aDoctorChamber.FriToTime != null)
{
aDoctorChamber.FriFromTime = aDoctorChamber.FriFromTime + " - " + aDoctorChamber.FriToTime;
}
if (aDoctorChamber.SatFromTime == null && aDoctorChamber.SatToTime == null)
{
aDoctorChamber.SatFromTime = "";
aDoctorChamber.SatToTime = "";
}
if (aDoctorChamber.SunFromTime == null && aDoctorChamber.SunToTime == null)
{
aDoctorChamber.SunFromTime = "";
aDoctorChamber.SunToTime = "";
}
if (aDoctorChamber.MonFromTime == null && aDoctorChamber.MonToTime == null)
{
aDoctorChamber.MonFromTime = "";
aDoctorChamber.MonToTime = "";
}
if (aDoctorChamber.TueFromTime == null && aDoctorChamber.TueToTime == null)
{
aDoctorChamber.TueFromTime = "";
aDoctorChamber.TueToTime = "";
}
if (aDoctorChamber.WedFromTime == null && aDoctorChamber.WedToTime == null)
{
aDoctorChamber.WedFromTime = "";
aDoctorChamber.WedToTime = "";
}
if (aDoctorChamber.ThuFromTime == null && aDoctorChamber.ThuToTime == null)
{
aDoctorChamber.ThuFromTime = "";
aDoctorChamber.ThuToTime = "";
}
if (aDoctorChamber.FriFromTime == null && aDoctorChamber.FriToTime == null)
{
aDoctorChamber.FriFromTime = "";
aDoctorChamber.FriToTime = "";
}
}
