public static WaivePackageStockMaterialCollection GetStockWaiveMaterialsByWaiveID(Int64 CaseID, Int64 CompanyID, DateTime DateFrom, DateTime DateTo, Int64 MaterialID)
{
WaivePackageStockMaterialCollection c = new WaivePackageStockMaterialCollection();
SqlCommand cmd = new SqlCommand();
SqlParameterCollection Params = cmd.Parameters;
Params.Add(new SqlParameter("CaseID", CaseID));
Params.Add(new SqlParameter("CompanyID", CompanyID));
Params.Add(new SqlParameter("DateFrom", DateFrom));
Params.Add(new SqlParameter("DateTo", DateTo));
if (MaterialID > 0)
{
Params.Add(new SqlParameter("MaterialID", MaterialID));
}
DataTable dt = Execute.FillDataTable(StoredProcedures.GetAllWaiveMaterialsByCompanyIDAndDate, Params);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
WaivePackageStockMaterial o = new WaivePackageStockMaterial();
LoadWaivePackageStockMaterial(row, o, true);
c.Add(o);
}
}
return(c);
}
public static WaivePackageStockMaterialCollection GetStockWaiveMaterialsByWaiveID(Int64 WaiveID)
{
WaivePackageStockMaterialCollection c = new WaivePackageStockMaterialCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetStockWaiveMaterialsByWaiveID, new SqlParameter("WaiveID", WaiveID));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
WaivePackageStockMaterial o = new WaivePackageStockMaterial();
LoadWaivePackageStockMaterial(row, o, false);
c.Add(o);
}
}
return(c);
}
