public SKU Get(long SKUID)
{
PackingType_DL objPackingType_DL = new PackingType_DL(Connection);
SKU objSKU = new SKU();
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_SKUID", SKUID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_SKUByID", paramList);
objSKU.SKUCost = Convert.ToDecimal(dt.Rows[0]["SKUCost"]);
objSKU.SKUDescription = Convert.ToString(dt.Rows[0]["SKUDescription"]);
objSKU.SKUID = Convert.ToInt64(dt.Rows[0]["SKUID"]);
objSKU.SKUPackingType = objPackingType_DL.Get(Convert.ToInt64(dt.Rows[0]["SKUPackingType"]));
objSKU.SKUQty = Convert.ToDecimal(dt.Rows[0]["SKUQty"]);
return(objSKU);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public FinishProductCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_FinishProduct_DataView");
FinishProductCollec objCollec = new FinishProductCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
FinishProduct objFinishProduct = new FinishProduct();
objFinishProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[i]["BasicProductCode"]));
objFinishProduct.BasicProductQty = Convert.ToDecimal(dt.Rows[i]["FinishProdutBasicQty"]);
objFinishProduct.FinishProductAvgCost = Convert.ToDecimal(dt.Rows[i]["FinishProdutAvgCost"]);
objFinishProduct.FinishProductCode = Convert.ToString(dt.Rows[i]["FinishProductCode"]);
objFinishProduct.FinishProductDescription = Convert.ToString(dt.Rows[i]["FinishProductDescription"]);
objFinishProduct.FinishProductFormula = objFormula_DL.Get(Convert.ToInt32(dt.Rows[i]["FinishProdutFormulaID"]));
objFinishProduct.FinishProductPackingType = objPackingType_DL.Get(Convert.ToInt64(dt.Rows[i]["FinishProdutPackingTypeID"]));
objFinishProduct.FinishProductStatus = Convert.ToBoolean(dt.Rows[i]["FinishProductStatus"]);
objFinishProduct.FinishProductType = Convert.ToString(dt.Rows[i]["FinishProductType"]);
objFinishProduct.PrimaryFinishProductQty = Convert.ToDecimal(dt.Rows[i]["PrimaryFinishProductQty"]);
objFinishProduct.SKUID = Convert.ToInt32(dt.Rows[i]["SKUID"]);
objCollec.Add(objFinishProduct);
}
return(objCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}