public GRNBasicProductsCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNBasicProduct");
GRNBasicProductsCollec objGRNBasicProductsCollec = new GRNBasicProductsCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
GRNBasicProducts objGRNBasicProduct = new GRNBasicProducts();
objGRNBasicProduct.BasicProduct = objBasicProduct_DL.Get(Convert.ToString(dt.Rows[i]["BasicProductCode"]));
objGRNBasicProduct.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"]));
objGRNBasicProduct.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]);
objGRNBasicProduct.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]);
objGRNBasicProduct.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]);
objGRNBasicProduct.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]);
objGRNBasicProductsCollec.Add(objGRNBasicProduct);
}
return(objGRNBasicProductsCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
