public Decimal GetAvailableQty(String Code)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ItemCode", Code)
};
return(Execute.RunSP_Decimal(Connection, "SPGET_Stock_AvailableQty_By_ItemCode", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public Decimal Get_AvailableQty(long GRNNO, String Code)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", GRNNO),
new SqlParameter("@FinishProductCode", Code)
};
return(Execute.RunSP_Decimal(Connection, "SPGET_GRN_ISSUE_FinishProduct_Available", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public Decimal Get_AvailableQty(long GRNNO, String MaterialCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@GRNNO", GRNNO),
new SqlParameter("@MaterialCode", MaterialCode)
};
return(Execute.RunSP_Decimal(Connection, "SPGET_GRNMaterials_ByID ", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
