public SalesEnquiryOptionQM GetSalesEnquiryForGrid(DateTime FromDate, DateTime ToDate, Int16 WorkOrdeType, Int16 Option, string Type) { SalesEnquiryOptionQM salesEnquiryOptionQM = new SalesEnquiryOptionQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetSalesEnquiryForGridSelectCommand { Connection = connection }; salesEnquiryOptionQM = command.Execute(FromDate, ToDate, WorkOrdeType, Option, Type); } return(salesEnquiryOptionQM); }
public SalesEnquiryOptionQM Execute(DateTime FromDate, DateTime ToDate, Int16 WorkOrdeType, Int16 Option, string Type) { SalesEnquiryOptionQM response = new SalesEnquiryOptionQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetSalesEnquiry]"; 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("@WorkOrderType", SsDbType.SmallInt, ParameterDirection.Input, WorkOrdeType)); sqlCommand.Parameters.Add(AddParameter("@IsOption", SsDbType.SmallInt, ParameterDirection.Input, Option)); sqlCommand.Parameters.Add(AddParameter("@Type", SsDbType.NVarChar, ParameterDirection.Input, Type)); using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.getSalesEnquiryOptionModel = reader.ToList <SalesEnquiryOptionModel>(); } } return(response); }