public DataSet Execute()
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetToBeInvoicedEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(Int16 Option)
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetStockOptionEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@Option", SsDbType.SmallInt, ParameterDirection.Input, Option));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(string SerialNo)
{
DataSet ds = new DataSet();
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));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(DateTime FromDate)
{
DataSet ds = new DataSet();
using (var sqlCommand = CreateCommand())
{
sqlCommand.Connection = Connection;
sqlCommand.CommandText = "[dbo].[uspGetDeliveryFollowUpEnquiry]";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(AddParameter("@CutOffDate", SsDbType.DateTime, ParameterDirection.Input, FromDate));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(Int16 Option, DateTime?fromDate, DateTime?ToDate)
{
DataSet ds = new DataSet();
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));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}
public DataSet Execute(DateTime FromDate, DateTime ToDate, Int16 WorkOrdeType, Int16 Option, string Type)
{
DataSet ds = new DataSet();
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));
ds = SsDbCommandHelper.ExecuteDataset(sqlCommand);
}
return(ds);
}