Object IGetRecord.GetRecord(String UserID) { DAL.UserConsumerDetails UScons = new UserConsumerDetails(); try { UScons = DAL.DALSearch.UserConsumerDetails(UserID); } catch (Exception ex) { throw; } return UScons; }
public static UserConsumerDetails UserConsumerDetails(String UserID) { UserConsumerDetails Consumer = new UserConsumerDetails (); using (var context = new SycousCon()) { try { var pUserID = new SqlParameter { ParameterName = "UserID", Value = UserID, Direction = ParameterDirection.Input }; Consumer = context.ExecuteStoreQuery<UserConsumerDetails>("exec [SYCOUS].[GetConsumerSearchInfo] @UserID", pUserID).FirstOrDefault(); } catch (Exception ex) { context.Dispose(); throw; } }//using return Consumer; }