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