public DespatchEnquiryOptionQM GetDespatchEnquiryForGrid(Int16 Option, DateTime?fromDate, DateTime?ToDate) { DespatchEnquiryOptionQM ds = new DespatchEnquiryOptionQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetDespatchEnquirySelectCommandForGrid { Connection = connection }; ds = command.Execute(Option, fromDate, ToDate); } return(ds); }
public DespatchEnquiryOptionQM Execute(Int16 Option, DateTime?fromDate, DateTime?ToDate) { DespatchEnquiryOptionQM response = new DespatchEnquiryOptionQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetDespatchEnquiry]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@FromDate", SsDbType.DateTime, ParameterDirection.Input, fromDate)); sqlCommand.Parameters.Add(AddParameter("@ToDate", SsDbType.DateTime, ParameterDirection.Input, ToDate)); sqlCommand.Parameters.Add(AddParameter("@IsOption", SsDbType.SmallInt, ParameterDirection.Input, Option)); using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.getDespatchEnquiryOptionModel = reader.ToList <DespatchEnquiryOptionModel>(); } } return(response); }