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);
}
