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