public SerialNoEnquiryOptionQM GetSerialNoEnquiryForGrid(string SerialNo) { SerialNoEnquiryOptionQM ds = new SerialNoEnquiryOptionQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetSerialNoEnquirySelectCommandForGrid { Connection = connection }; ds = command.Execute(SerialNo); } return(ds); }
public SerialNoEnquiryOptionQM Execute(string SerialNo) { SerialNoEnquiryOptionQM response = new SerialNoEnquiryOptionQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetSerialNoEnquiry]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@SerialNo", SsDbType.NVarChar, ParameterDirection.Input, SerialNo)); using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.getSerialNoEnquiryOptionModel = reader.ToList <SerialNoEnquiryOptionModel>(); } } return(response); }