public GetDespatchDetailsEnquiryQM GetDespatchDetailsEnquiryForGrid(DateTime FromDate, DateTime ToDate) { GetDespatchDetailsEnquiryQM getDespatchDetailsEnquiryQM = new GetDespatchDetailsEnquiryQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetDespatchDetailsEnquiryForGridSelectCommand { Connection = connection }; getDespatchDetailsEnquiryQM = command.Execute(FromDate, ToDate); } return(getDespatchDetailsEnquiryQM); }
public GetDespatchDetailsEnquiryQM Execute(DateTime FromDate, DateTime ToDate) { GetDespatchDetailsEnquiryQM response = new GetDespatchDetailsEnquiryQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetDespatchDetailsEnquiry]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@FromDate", SsDbType.DateTime, ParameterDirection.Input, FromDate)); sqlCommand.Parameters.Add(AddParameter("@ToDate", SsDbType.DateTime, ParameterDirection.Input, ToDate)); using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.GetDespatchDetailsEnquiryModelList = reader.ToList <GetDespatchDetailsEnquiryModel>(); } } return(response); }