/// <summary>
/// Add parameters while getting the stock report
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public IDbDataParameter[] AddParamsGetStockReportDomain(StockDetailsDomain StockDetailsDomain)
{
parameters.Clear();
parameters.Add(dbManager.CreateParameter("@BrandCode", 9, StockDetailsDomain.BrandCode, DbType.Int32));
parameters.Add(dbManager.CreateParameter("@BrandName", 100, StockDetailsDomain.BrandName, DbType.String));
parameters.Add(dbManager.CreateParameter("@ColorCode", 9, StockDetailsDomain.ColorCode, DbType.Int32));
parameters.Add(dbManager.CreateParameter("@OperationType", 2, StockDetailsDomain.OperationType, DbType.Int16));
return(parameters.ToArray());
}
/// <summary>
/// Add parameters while getting the stock details
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public IDbDataParameter[] AddParamsGetStockDetailsDomain(StockDetailsDomain StockDetailsDomain)
{
parameters.Clear();
parameters.Add(dbManager.CreateParameter("@StockId", 9, StockDetailsDomain.StockId, DbType.Int32));
parameters.Add(dbManager.CreateParameter("@FromDate", StockDetailsDomain.FromDate, DbType.Date));
parameters.Add(dbManager.CreateParameter("@ToDate", StockDetailsDomain.ToDate, DbType.Date));
parameters.Add(dbManager.CreateParameter("@BrandName", 100, StockDetailsDomain.BrandName, DbType.String));
parameters.Add(dbManager.CreateParameter("@OperationType", 2, StockDetailsDomain.OperationType, DbType.Int16));
return(parameters.ToArray());
}
/// <summary>
/// To get the stock report list..
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public DataTable StockReportDomain(StockDetailsDomain StockDetailsDomain)
{
var DbManager = new DBManager("DBConnection");
return(DbManager.GetDataTable(_StoredProcedures.GetStockReport_SP, CommandType.StoredProcedure, _SalesIRepository.AddParamsGetStockReportDomain(StockDetailsDomain)));
}
