protected static bool UpdateDetail(OrderDetail orderDetail, DbTransaction pTransaction, string executedBy)
        {
            bool rslt = false;

            try
            {
                Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection);
                DbCommand cmd = db.GetStoredProcCommand(Constants.SP_OrderDetails_Update);

                db.AddInParameter(cmd, "OrderDetailID", DbType.Int32, orderDetail.OrderDetailID);
                db.AddInParameter(cmd, "OrderID", DbType.Int32, orderDetail.OrderID);
                db.AddInParameter(cmd, "ItemID", DbType.Int32, orderDetail.ItemID);
                db.AddInParameter(cmd, "OrderQty", DbType.Int32, orderDetail.OrderQty);
                db.AddInParameter(cmd, "UpdatedBY", DbType.Int32, orderDetail.UpdatedBy);

                db.ExecuteNonQuery(cmd, pTransaction);
                rslt = true;
            }

            catch (Exception ex)
            {
                rslt = false;
                throw ex;
            }

            return rslt;
        }
        protected static bool InsertDetail(OrderDetail orderDetail, DbTransaction pTransaction, string executedBy)
        {
            bool rslt = false;

            try
            {
                Database db = DatabaseFactory.CreateDatabase(Constants.DBConnection);
                DbCommand cmd = db.GetStoredProcCommand(Constants.SP_OrderDetails_Insert);

                db.AddInParameter(cmd, "OrderID", DbType.Int32, orderDetail.OrderID);
                db.AddInParameter(cmd, "ItemID", DbType.Int32, orderDetail.ItemID);
                db.AddInParameter(cmd, "OrderQty", DbType.Int32, orderDetail.OrderQty);

                db.AddInParameter(cmd, "CreatedBy", DbType.Int32, orderDetail.CreatedBy);

                db.AddOutParameter(cmd, "NewID", DbType.Int32, 4);

                db.ExecuteNonQuery(cmd, pTransaction);

                int newID = 0;
                int.TryParse(db.GetParameterValue(cmd, "NewID").ToString(), out newID);

                if (newID > 0)
                    rslt = true;
            }

            catch (Exception ex)
            {
                rslt = false;
                throw ex;
            }

            return rslt;
        }