public static void GetActualOrderRevStep( IOrderSummaryDetail ordersummarydetail, out System.Decimal result)
{
// TODO: Complete business rule implementation
using (ISession session = new SessionScopeWrapper()) {
string sql = "select revenue from order_summary_detail where ordertype='Actual' and order_summary_detailid='" + ordersummarydetail.Id.ToString() + "'";
decimal fswon = session.CreateSQLQuery(sql).UniqueResult<decimal>();
result = fswon;
}
}
public static void GetProductName( IOrderSummaryDetail ordersummarydetail, out System.String result)
{
using (ISession session = new SessionScopeWrapper())
{
string sql = "select description from product where productid='"+ordersummarydetail.Productid.ToString()+"'";
string prodname = session.CreateSQLQuery(sql).UniqueResult<string>();
result=prodname;
}
}