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