public ClsGetAppointmentDetail GetAppointmentDetails(string ACEApptId, int ApptId)
{
ClsGetAppointmentDetail GetAppointmentDetails = new ClsGetAppointmentDetail();
using (IDbConnection con = new SqlConnection(ConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@ACEApptId", ACEApptId);
parameters.Add("@ACEApptId", ACEApptId);
GetAppointmentDetails = con.Query <ClsGetAppointmentDetail>("GetAppointmentDetails", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
return(GetAppointmentDetails);
}
public ClsGetAppointmentDetail GetBookedAppointments(int UserId, string CounsellerId, string Location, DateTime FromDateInUTC, DateTime ToDateInUTC)
{
ClsGetAppointmentDetail AppointmentList = new ClsGetAppointmentDetail();
using (IDbConnection con = new SqlConnection(ConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@UserId", UserId);
parameters.Add("@CounsellerId", CounsellerId);
parameters.Add("@StartDateInUTc", FromDateInUTC);
parameters.Add("@EndDateInUTC", ToDateInUTC);
parameters.Add("@Location", Location);
//parameters.Add("@type", UserId);
AppointmentList = con.Query <ClsGetAppointmentDetail>("EAPGetLocationFROMAppintments", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault();
}
return(AppointmentList);
}
