public bool EditDoctorSchedule(AssignedDoctors assignedDoctors)
{
Query = "UPDATE AssignedDoctors SET Sat = @sat, Sun = @sun, Mon = @mon, Tue = @tue, Wed = @wed, Thu = @thu, Fri = @fri, SatTime = @satTime, SunTime = @sunTime, MonTime = @monTime, TueTime = @tueTime, WedTime = @wedTime, ThuTime = @thuTime, FriTime = @friTime WHERE MedicalId = @medicalId AND DoctorId = @doctorId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("sat", assignedDoctors.Sat);
Command.Parameters.AddWithValue("sun", assignedDoctors.Sun);
Command.Parameters.AddWithValue("mon", assignedDoctors.Mon);
Command.Parameters.AddWithValue("tue", assignedDoctors.Tue);
Command.Parameters.AddWithValue("wed", assignedDoctors.Wed);
Command.Parameters.AddWithValue("thu", assignedDoctors.Thu);
Command.Parameters.AddWithValue("fri", assignedDoctors.Fri);
Command.Parameters.AddWithValue("satTime", assignedDoctors.SatFromTime);
Command.Parameters.AddWithValue("sunTime", assignedDoctors.SunFromTime);
Command.Parameters.AddWithValue("monTime", assignedDoctors.MonFromTime);
Command.Parameters.AddWithValue("tueTime", assignedDoctors.TueFromTime);
Command.Parameters.AddWithValue("wedTime", assignedDoctors.WedFromTime);
Command.Parameters.AddWithValue("thuTime", assignedDoctors.ThuFromTime);
Command.Parameters.AddWithValue("friTime", assignedDoctors.FriFromTime);
Command.Parameters.AddWithValue("medicalId", assignedDoctors.MedicalId);
Command.Parameters.AddWithValue("doctorId", assignedDoctors.DoctorId);
Connection.Open();
bool rowAffected = Convert.ToBoolean(Command.ExecuteNonQuery());
Connection.Close();
return(rowAffected);
}
public bool SaveAssignedDoctor(AssignedDoctors assignedDoctors)
{
Query = "INSERT INTO AssignedDoctors VALUES(@medicalId, @doctorId, @doctorFee, @returningFee, @sat, @sun, @mon, @tue, @wed, @thu, @fri, @satTime, @sunTime, @monTime, @tueTime,@wedTime,@thuTime,@friTime)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("medicalId", assignedDoctors.MedicalId);
Command.Parameters.AddWithValue("doctorId", assignedDoctors.DoctorId);
Command.Parameters.AddWithValue("doctorFee", assignedDoctors.DoctorFee);
Command.Parameters.AddWithValue("returningFee", assignedDoctors.DoctorReturningFee);
Command.Parameters.AddWithValue("sat", assignedDoctors.Sat);
Command.Parameters.AddWithValue("sun", assignedDoctors.Sun);
Command.Parameters.AddWithValue("mon", assignedDoctors.Mon);
Command.Parameters.AddWithValue("tue", assignedDoctors.Tue);
Command.Parameters.AddWithValue("wed", assignedDoctors.Wed);
Command.Parameters.AddWithValue("thu", assignedDoctors.Thu);
Command.Parameters.AddWithValue("fri", assignedDoctors.Fri);
Command.Parameters.AddWithValue("satTime", assignedDoctors.SatFromTime);
Command.Parameters.AddWithValue("sunTime", assignedDoctors.SunFromTime);
Command.Parameters.AddWithValue("monTime", assignedDoctors.MonFromTime);
Command.Parameters.AddWithValue("tueTime", assignedDoctors.TueFromTime);
Command.Parameters.AddWithValue("wedTime", assignedDoctors.WedFromTime);
Command.Parameters.AddWithValue("thuTime", assignedDoctors.ThuFromTime);
Command.Parameters.AddWithValue("friTime", assignedDoctors.FriFromTime);
Connection.Open();
bool rowAffected = Convert.ToBoolean(Command.ExecuteNonQuery());
Connection.Close();
return(rowAffected);
}
public string EditDoctorFees(AssignedDoctors aAssignedDoctor)
{
bool rowAffected = aDoctorGateway.EditDoctorFees(aAssignedDoctor);
if (rowAffected)
{
return("Success");
}
else
{
return("Doctor fees editing failed.");
}
}
public string EditDoctorSchedule(AssignedDoctors assignedDoctors)
{
bool rowAffected = aMedicalGateway.EditDoctorSchedule(assignedDoctors);
if (rowAffected)
{
return("Success");
}
else
{
return("Doctor schedule editing failed.");
}
}
public string AddDoctorFromOtherMedical(AssignedDoctors aAssignedDoctor)
{
bool rowAffected = aMedicalGateway.SaveAssignedDoctor(aAssignedDoctor);
if (rowAffected)
{
return("Success");
}
else
{
return("Doctor assigning failed.");
}
}
