public ClsReservationParametres GetReservationParameters(ClsReservations model) { ClsReservationParametres ServiceTypesList = new ClsReservationParametres(); using (IDbConnection con = new SqlConnection(ConnectionString)) { if (con.State == ConnectionState.Closed) { con.Open(); } DynamicParameters parameters = new DynamicParameters(); parameters.Add("@UserId", model.UserId); parameters.Add("@ActivityTypeFlag", model.ActivityTypeFlag); ServiceTypesList = con.Query <ClsReservationParametres>("ACEGetReservationParameters", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault(); } return(ServiceTypesList); }
public ClsReservationParametres GetReservationParameters(ClsReservations model) { return(_aceRepository.GetReservationParameters(model)); }