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