public GRNMaterialsCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNMaterials");
GRNMaterialsCollec objGRNMatCollec = new GRNMaterialsCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
GRNMaterials objGRNMaterial = new GRNMaterials();
objGRNMaterial.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"]));
objGRNMaterial.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]);
objGRNMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["MaterialCode"]));
objGRNMaterial.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]);
objGRNMaterial.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]);
objGRNMaterial.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]);
objGRNMatCollec.Add(objGRNMaterial);
}
return(objGRNMatCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
