public AppointmentDO GetAppointmentByDoctorId(int doctorId)
{
DataTable dtOrganization = _objOrganizationDAL.GetOrganizationByDoctorId(doctorId);
AppointmentDO a = new AppointmentDO();
if (dtOrganization.Rows.Count > 0)
{
a.DoctorId = doctorId;
a.DoctorName = dtOrganization.Rows[0]["DoctorName"].ToString();
a.DoctorNameWithDegree = dtOrganization.Rows[0]["DoctorNameWithDegree"].ToString();
a.OrganizationId = Convert.ToInt32(dtOrganization.Rows[0]["OrganizationId"].ToString());
a.OrganizationName = dtOrganization.Rows[0]["OrganizationName"].ToString();
a.BranchName = dtOrganization.Rows[0]["BranchName"].ToString();
//if (dtOrganization.Rows[0]["AddressLine2"].ToString() == string.Empty)
// a.Address = dtOrganization.Rows[0]["AddressLine1"].ToString() + "\n" + dtOrganization.Rows[0]["CityName"].ToString() + "\n" + dtOrganization.Rows[0]["StateName"].ToString() + "\n" + dtOrganization.Rows[0]["CountryName"].ToString() + "\n" + dtOrganization.Rows[0]["PostalCode"].ToString() + "\nPhone: " + dtOrganization.Rows[0]["Phone"].ToString(); // + "\nMobile: " + dtOrganization.Rows[0]["Mobile"].ToString();
//else
a.Address = dtOrganization.Rows[0]["Address"].ToString().Trim() + dtOrganization.Rows[0]["CityName"].ToString() + "\n" + dtOrganization.Rows[0]["StateName"].ToString() + "\n" + dtOrganization.Rows[0]["CountryName"].ToString() + "\n" + dtOrganization.Rows[0]["PostalCode"].ToString() + "\nPhone: " + dtOrganization.Rows[0]["Phone"].ToString(); // +"\nMobile: " + dtOrganization.Rows[0]["Mobile"].ToString();
return a;
}
else
{
return a;
}
}
public AppointmentDO GetAppointmentByServiceId(int serviceId)
{
DataTable dtOrganization = _objOrganizationDAL.GetOrganizationByServiceId(serviceId);
AppointmentDO a = new AppointmentDO();
if (dtOrganization.Rows.Count > 0)
{
a.ServiceId = serviceId;
a.Service = dtOrganization.Rows[0]["ServiceName"].ToString();
a.OrganizationId = Convert.ToInt32(dtOrganization.Rows[0]["OrganizationId"].ToString());
a.OrganizationName = dtOrganization.Rows[0]["OrganizationName"].ToString();
a.BranchName = dtOrganization.Rows[0]["BranchName"].ToString();
//if (dtOrganization.Rows[0]["AddressLine2"].ToString() == string.Empty)
// a.Address = dtOrganization.Rows[0]["AddressLine1"].ToString() + "\n" + dtOrganization.Rows[0]["CityName"].ToString() + "\n" + dtOrganization.Rows[0]["StateName"].ToString() + "\n" + dtOrganization.Rows[0]["CountryName"].ToString() + "\n" + dtOrganization.Rows[0]["PostalCode"].ToString() + "\nPhone: " + dtOrganization.Rows[0]["Phone"].ToString();// + "\nMobile: " + dtOrganization.Rows[0]["Mobile"].ToString();
//else
a.Address = dtOrganization.Rows[0]["Address"].ToString().Trim() + "\n" + dtOrganization.Rows[0]["CityName"].ToString() + "\n" + dtOrganization.Rows[0]["StateName"].ToString() + "\n" + dtOrganization.Rows[0]["CountryName"].ToString() + "\n" + dtOrganization.Rows[0]["PostalCode"].ToString() + "\nPhone: " + dtOrganization.Rows[0]["Phone"].ToString();// +"\nMobile: " + dtOrganization.Rows[0]["Mobile"].ToString();
return(a);
}
else
{
return(a);
}
}
public AppointmentDO GetOrganizationByServiceTimingId(int serviceTimingId)
{
DataTable dtOrganization = _objAppointmentDAL.GetOrganizationByServiceTimingId(serviceTimingId);
AppointmentDO a = null;
if (dtOrganization.Rows.Count > 0)
{
a = new AppointmentDO();
a.OrganizationId = Convert.ToInt32(dtOrganization.Rows[0]["OrganizationId"].ToString());
a.OrganizationName = dtOrganization.Rows[0]["OrganizationName"].ToString();
a.Address = dtOrganization.Rows[0]["ScheduleAddress"].ToString();
a.ServiceId = Convert.ToInt32(dtOrganization.Rows[0]["ServiceId"].ToString());
}
return(a);
}
public DataRow SaveAppointment(AppointmentDO a)
{
return(_objAppointmentDAL.SaveAppointment(a.PatientId, a.OrganizationId, a.ServiceId, a.ServiceTimingId, a.DoctorId, a.DoctorTimingId, a.AppointmentDate, a.AppointmentTime, a.OnCallAppointmentTime, a.Notes, a.IsCarParkFacility, a.CarNumber, a.PreferentialId, a.PreferentialBoarding, a.StatusId, a.IsDirectAppointment));
}
public DataRow SaveAppointment(AppointmentDO a)
{
return _objAppointmentDAL.SaveAppointment(a.PatientId, a.OrganizationId, a.ServiceId, a.ServiceTimingId, a.DoctorId, a.DoctorTimingId, a.AppointmentDate, a.AppointmentTime, a.OnCallAppointmentTime, a.Notes, a.IsCarParkFacility, a.CarNumber, a.PreferentialId, a.PreferentialBoarding, a.StatusId, a.IsDirectAppointment);
}
public AppointmentDO GetOrganizationByServiceTimingId(int serviceTimingId)
{
DataTable dtOrganization = _objAppointmentDAL.GetOrganizationByServiceTimingId(serviceTimingId);
AppointmentDO a = null;
if (dtOrganization.Rows.Count > 0)
{
a = new AppointmentDO();
a.OrganizationId = Convert.ToInt32(dtOrganization.Rows[0]["OrganizationId"].ToString());
a.OrganizationName = dtOrganization.Rows[0]["OrganizationName"].ToString();
a.Address = dtOrganization.Rows[0]["ScheduleAddress"].ToString();
a.ServiceId = Convert.ToInt32(dtOrganization.Rows[0]["ServiceId"].ToString());
}
return a;
}
