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